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