Total Pageviews

October 23, 2016

10/23/2016 09:33:00 PM

          Oracle eBusiness Suite: Payables R12 upgrade

Oracle r12 payable tables

Suppliers

New R12 tables  -> Old 11i Tables
AP_SUPPLIERS - replaces PO_VENDORS
AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SITES_ALL

Additional supplier related tables in IBY(Payments) and HZ(TCA): 
  • IBY_EXTERNAL_PAYEES_ALL - stores Payee(supplier) information.
  • HZ_PARTIES - Party data for the suppliers.
  • HZ_PARTY_SITES - Party site data for the supplier sites.

Invoices
Additional table in R12: AP_INVOICE_LINES_ALL
Allocations - ap_chrg_allocations_all is obsolete in R12

Taxes

Functionality provided by E-Business Tax
New tables in R12
  • ZX_LINES - Detailed Tax lines for the invoice (trx_id = invoice_id)
  • ZX_LINES_SUMMARY - Summary tax lines for the invoice (trx_id = invoice_id)
  • ZX_REC_NREC_DIST  - Tax distributions for the invoice (trx_id = invoice_id)
  • ZX_LINES_DET_FACTORS - Tax determination factors for the invoice (trx_id = invoice_id)

Payments

Functionality moved to central Payments (IBY)

New IBY tables in R12:
  1. IBY_PAY_SERVICE_REQUESTS  - Payment Process Request information                                                                          (11i Terminology is  Payment Batch)
  2. IBY_PAY_INSTRUCTIONS_ALL - Payment Instruction information
  3. IBY_DOC_PAYABLES_ALL - Invoice information stored by IBY for generating payment
  4. IBY_PAYMENTS_ALL - Payment Information


The following AP tables are still in use in R12 to store payment related information.
  • AP_INVOICE_PAYMENTS_ALL
  • AP_CHECKS_ALL 
  • AP_PAYMENT_HISTORY_ALL 



Accounting
Functionality moved to SubLedger Accounting (SLA)

New R12 tables:
  • XLA_EVENTS -> replaces AP_ACOCUNTING_EVENTS_ALL  
  • XLA_AE_HEADERS -> replaces AP_AE_HEADERS_ALL
  • XLA_AE_LINES-> replaces AP_AE_LINES_ALL
  • XLA_DISTRIBUTION_LINKS


Trial Balance

New R12 Table 
  • XLA_TRIAL_BALANCES

AP_LIABILITY_BALANCE-> not used in new R12 transactions
AP_TRIAL_BALANCE -> not used in new R12 transactions

Bank Accounts

Functionality moved to Cash Management.
  • CE_BANK_ACCOUNTS -> replaces AP_BANK_ACCOUNTS_ALL
  • CE_BANK_ACCT_USES_ALL  -> replaces AP_BANK_ACCOUNT_USES_ALL 
  • CE_PAYMENT_DOCUMENTS -> AP_CHECK_STOCKS_ALL