Payment data in Sub-Ledger Accounting (XLA) – R12

To check the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ) in Sub-Ledger Accounting (XLA). All the queries given in this post and their related posts were tested in R12.1.1 Instance. XLA_EVENTS […]

How Payable Invoices related Reconciliation and Currencies Data is stored in Oracle Apps R12

We will find the tables involved in storing the Reconciliation and Currency Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in […]

Query fetching both Prepayment Data and Invoice Data of a Payable Invoice

We will find a query which fetches both invoice and prepayment information of a payable invoice ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in […]

How Payable Invoices Data is stored in Sub-ledger Accounting of Oracle Apps R12

We will check the Data related to the Payable INVOICE ( Invoice_id = 166014 ) in Sub-Ledger Accounting (XLA). All the queries given in this post and their related posts were tested in R12.1.1 Instance. XLA_EVENTS SELECT DISTINCT xe.* […]

How Payable Invoices related data is stored in Oracle Apps R12

Tables involved in storing the Data related to an PAYABLE INVOICE ( Invoice_id = 166014 ) in various modules of Oracle Apps R12. All the queries given in this post and their related posts were tested in […]

R12: AP: How Can You Prevent Suppliers From Being Created in Supplier Inquiry?

Goal: How can you prevent suppliers from being created in Supplier Inquiry? Create Supplier button is available in Payables Supplier Inquiry page. Should not be able to create suppliers in supplier inquiry page but it […]

How To Setup The Supplier Form To Be Read-Only Mode

R12: How To Set The Suppliers Form To Be Used In Read-Only Mode? This is done by excluding the function ‘Supplier Full Access: Buyer View’ in the Menu linked to the responsibility for which you […]

R12 Payment Process Request – Functional and Technical Information

Payment Process Requests Overview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process Requests. There […]

How to import Concur Expense (SAE) data into Oracle Application (GL:General Ledger)

==================================================== Oracle (EBusiness Suite 11i/R12) – Concur Expense Integration. ==================================================== Are you using Concur cloud application for expenses and want to post expense data into your oracle application General Ledger module? No Problem, we […]

How to Configure to send e-Mail Separate Remittance Advice

Configure BI (XML) Publisher Separate Remittance Advice (SRA) Delivery. 1. Create the instance specific xdodelivery.cfg file Reference: Oracle® XML Publisher Administration and Developer’s Guide Release 12 Part No. B31412-01 December 2006 Page 7-45 provides an […]