New Features in Oracle apps R12

What's new on Oracle R12:

1. Multi-org Access Control (MOAC)
    - Access Multiple Operating Units Within a Single Application Responsibility.
    - Set column MULTI_ORG_CATEGORY on table FND_CONCURRENT_PROGRAMS to 'S' - single or 'M' - Multi,
      for Multi-org Access.
    - Set MO_GLOBAL.SET_POLICY_CONTEXT('S', ORG_ID); when running views on SQL tools
2. Enhanced TCA model
    - HZ_CUSTOMER_PROFILES replace AR_CUSTOMER_PROFILES (11i)
    - AR_ADDRESSES_V replace RA_ADDRESSES (11i)
    - AR_SITE_USES_V replace RA_SITE_USES (11i)
    - AR_CUSTOMERS replace RA_CUSTOMERS (11i)
    - HZ_CONTACT_POINTS where OWNER_TABLE_NAME = 'HZ_PARTIES' and
      CONTACT_POINT_TYPE = 'PHONE' replace RA_PHONES (11i)
    - AR_CONTACTS_V replace RA_CONTACTS
3. SLA - Sub-ledger Accounting (see GL Tables)
    - Reference columns on table GL_JE_LINES are no more used.
    Sub ledger data retrieved from below tables.

 1. GL_JE_BATCHES (je_batch_id)

     => GL_JE_HEADERS (je_batch_id)

 2. GL_JE_HEADERS (je_header_id)

     => GL_JE_LINES (je_header_id)

 3. GL_JE_LINES (je_header_id, je_line_num)

     => GL_IMPORT_REFERENCES (je_header_id, je_line_num)

 4. GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)

     => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)

 5. XLA_AE_LINES (application_id, ae_header_id)

      => XLA_AE_HEADERS (application_id, ae_header_id)

 6. XLA_AE_HEADERS (application_id, event_id)

     => XLA_EVENTS (application_id, event_id)

 7. XLA_EVENTS (application_id, entity_id)

     => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id)
 8.  XLA.XLA_TRANSACTION_ENTITIES(SOURCE_ID_INT_1)
            => Subledger tables
4. New Payments and Bank Model (see AP Payment tables)
    - CE_BANK_ACCOUNTS replace AP_BANK_ACCOUNTS_ALL (11i)
    - CE_BANK_ACCT_USES_ALL replace AP_BANK_ACCOUNT_USES_ALL(11i)
    - CE_BANK_BRANCHES_V replace AP_BANK_BRANCHS_ALL(11i)
    - New table added:  AP_INVOICE_LINES_ALL


5. E-business Tax
    - ZX_TAXES_B – Tax codes are stored
    - All tax related tables from Payables and Receivables are no longer use