Difference Between R12 and 11i Modules Wise

Difference Between R12 and 11i Modules Wise

Difference Between R12 and 11i Modules Wise

First we discuss about  MOAC and then Modules wise what changes comes 11i to R12.

Multi – Org Concept in Oracle Apps R12: MOAC (Multiorg Access Control)

Multi-Org in simple term means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. 
The concept of Multi-Org will manage the operations of an enterprise which has got subsidiaries across globe under a single oracle apps window, 
taking appropriate care of data security and data maintenance.
It decides how transactions flow through different organizations and how those organizations interact with each other.

1. By MOAC (Multiorg Access Control) , we can be able to access  multiple operating units at a time.
2. Mutiorg views were replaced with MOAC Based synonyms.
3. MO:Security Profile is a new profile added in R12.
4. VPD(Virtual Private Database) System will take care of  Data security in R12

Org Initialisation process in R12 :

begin
   mo_global.set_policy_context('S','204');
 end;

MOAC Synonym Initialisation :
----------------------------
 begin
   FND_GLOBAL.APPS_INTILISE('APPLICATION_ID','RESPONSIBILTY_ID,'USER_ID');
   MO_GLOBAL.INIT('SQLAP'); -- Application Short Name
 end;


Modules Wise change 11i to R12

1) General Ledger :

1.gl_sets_of_books table was replaced with gl_ledgers and gl_ledger_Sets.
2.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 :

1.ap_invoice_lines_all table added in R12.
2.ap_invoice_distributions_all table populates the data when ever invoice gets accounted.
3.Supplier form was converted from form based solution to webbased solution.
4.po_vendors tables replaced with ap_suppliers tables.
5.Supplier and customer information was defined together Under TCA(Trading Community Architecture).
6.Accounting Tables were modified.
7.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_banks                 ce_banks
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                                                           R12
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
Subledger Accounting Balances Update  :  xla_ae_headers and xla_ae_lines -> xla_control_balances.


11i                                                             R12
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