How to Reconcile Account Payable with GL trial balance Run the Accounts Payable Trial Balance for a particular period which you have already closed (or) intend to close in both AP and GL. Now Run […]
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 […]
AP Trail Balances SQL Query for 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 […]
What is MICR? Magnetic Ink Character Recognition (MICR) is the line of numbers (ten numeric and four special symbols) on a document that relates a transaction to a specific customer’s account. Encoded checks are processed […]
Goal How does the Invoices Workbench (APXINWKB) determine the validation status of an invoice? The validation status of an invoice is displayed at invoice header level, but this information is not stored in the corresponding table AP_INVOICES_ALL […]
1) Payment Method Code at Supplier Level 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT supp.segment1 supplier_num, paym.payment_method_code FROM ap_suppliers supp, iby_external_payees_all payee, iby_ext_party_pmt_mthds paym WHERE supp.party_id = […]
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 […]
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 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 […]
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. […]
Enterprise Resource Planning and Integrations BlogSpot 