Supplier and Supplier Site Level External Bank Queries in R12
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]
Author: Yogesh Pachpute
Query Supplier’s phone, fax, and email in oracle R12
In Oracle EBS R12 supplier web page, there are Address Book and Contact Directory that contain phone, fax and email information. A) To gather phone, fax, and email in Address Book we can use this […]
Importing Supplier Bank Account through Interface Tables in R12
Importing Supplier Bank Account through Interface Tables in R12 The data to be imported is to be inserted in the interface tables first. After inserting the data in the interface tables, the ‘Supplier Open […]
How Payable Invoices related Payment Data is stored in Oracle Apps R12
To find the tables involved in storing the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in R12.1.1 Instance. […]
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 […]
Worktags in Workday
Worktags are keywords assigned to business events, so Workday customers can aggregate, report, and analyze their business information within Workday. One example: An employee fills out a purchase order (an event), which can be assigned […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 