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. […]
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 […]
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 […]
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 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 […]
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.* […]
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 […]
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 […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 