Difference Between 11i and R12

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

   Multi-Org in simple term means the implementation of multiple business units 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. We can be able to access  multiple operating units at a time.
   MO:Security Profile is a new profile added in R12.
     --
BEGIN
       mo_global.set_policy_context('S','104');
   FND_GLOBAL.APPS_INTILISE('APPLICATION_ID','RESPONSIBILTY_ID,'USER_ID');
     END;
--
   For Example: On Purchase Order form, at top of the form "Operating Unit" field: (See below screenshot)


2) 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 webbased solution.
   Supplier and customer information was defined together Under TCA(Trading Community Architecture).
   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.
 
   *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.

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

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

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

         11i                        R12
    AP_ACOCUNTING_EVENTS_ALL     XLA_EVENTS
    AP_AE_HEADERS_ALL            XLA_AE_HEADERS
    AP_AE_LINES_ALL              XLA_AE_LINES

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