Modules Wise changes in 11i to R12 Apps

/* Srikanth Yarram */
yarram52@gmail.com

Modules Wise changes in  11i to R12

1) General Ledger :

gl_sets_of_books table was replaced with gl_ledgers and gl_ledger_Sets.
4c’s comes in R12  Currency,Calendar,Chart of accounts, Accounting Convention , In 11i,  there are 3c’s ( Currency,Calendar,Chart of accounts)

2) Accounts Payable :

ap_invoice_lines_all table added in R12.
ap_invoice_distributions_all table populates the data when ever invoice gets accounted.
Supplier form was converted from form based solution to web based solution.
po_vendors tables replaced with ap_suppliers tables.
Supplier and customer information was defined together Under TCA(Trading Community Architecture).
Accounting Tables were modified.
Both supplier and customer bank information was defined under payments(New application in R12) Application.

11i Tables R12 Tables
========     ===========
po_vendors ap_suppliers
po_vendor_sites_all ap_supplier_sites_all
po_vendor_contacts ap_supplier_contacts
ap_bank_branches ce_bank_branches
ap_ae_headers_all xla_ae_headers
ap_ae_lines_all xla_ae_lines
ap_ae_accounting_events xla_events

3) Suppliers

11i Tables R12 Tables
========     ===========
po_vendors ap_suppliers
po_vendor_sites_all ap_supplier_sites_all
po_vendor_contacts ap_supplier_contacts

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.

4) Invoices:

In 11i , Only two table ,AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL but R12 Additional table  AP_INVOICE_LINES_ALL

Allocations – AP_CHRG_ALLOCATIONS_ALL is obsolete in R12

5) Bank Account Details

11i Tables R12 Tables
========     ===========
AP_BANK_ACCOUNTS_ALL CE_BANK_ACCOUNTS
AP_BANK_ACCOUNT_USES_ALL CE_BANK_ACCT_USES_ALL
AP_CHECK_STOCKS_ALL CE_PAYMENT_DOCUMENTS

6) Sub-ledger Accounting

SLA is rule based accounting hub in Release 12 (R12) of the Oracle E-Business Suite of applications. SLA is used to derive all attributes required to account a transaction in Oracle General Ledger.

SLA can be configured in many ways to help derive accounting attributes such as the entered amount, accounted amount, date, currency code as well as the more complex attributes like ledger, code combination ID (CCID). SLA accounting attributes are interfaced to GL from SLA, thus in R12 no sub ledger application module (i.e. AP, PO, PA etc) interfaces the transactions directly to GL.

Create Accounting :  Subledger tables and xla_events -> xla_ae_headers, xla_ae_lines and xla_distribution_links
Transfer to GL    : xla_ae_headers and xla_ae_lines -> gl_je_headers and gl_je_lines
Post to GL        : gl_je_headers and gl_je_lines -> gl_balances
Sub ledger Accounting Balances Update  :  xla_ae_headers and xla_ae_lines -> xla_control_balances

11i Tables R12 Tables
========     ===========
AP_ACOCUNTING_EVENTS_ALL XLA_EVENTS
AP_AE_HEADERS_ALL XLA_AE_HEADERS
AP_AE_LINES_ALL XLA_AE_LINES

7) 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

8) 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)

9) Order Management

RA_CUSTOMERS ,
RA_SITE_USES_ALL ,
RA_ADDRESSES_ALL
views were removed in R12. in place of ra_customers,ra_site_uses_all,ra_addresses_all views need to use the below mentioned base tables.

HZ_CUST_ACCOUNTS
HZ_PARTIES
HZ_CUST_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL
HZ_PARTY_SITES
HZ_LOCATIONS