Migrating Reports to Release 12 - Co-Existing & Obsolete Table details:
The Impact:
· Some 11i queries will easily migrate to Rel. 12
· Some with no changes at all
· Some will need table name changes
· Some 11i queries will need moderate attention
– Data moved to TCA will require query rewrites, but the basic reports can remain the
· same
· Some 11i queries won’t migrate 1:1 to Rel. 12
– SLA may require new reports, queries & ETL routines
Funds Disbursement Changes
Co-existing Tables
11i | R12 | |
Invoice payments | AP_INVOICES_ALL AP_PAYMENT_SCHEDULES_ALL | IBY_DOCS_PAYABLE_ALL |
Payments | AP_CHECKS_ALL | IBY_PAYMENTS_ALL |
Instructions, batches | AP_INV_SELECTION_CRITERIA_ALL | IBY_DOCS_PAYABLE_ALL IBY_PAY_SERVICE_REQUESTS IBY_PAY_INSTRUCTIONS_ALL |
Obsolete Tables
11i | R12 | |
Banks | AP_BANK_ACCOUNT_USES_ALL | CE_BANK_ACCT_USES_ALL |
Payment documents | AP_CHECK_STOCKS_ALL | CE_PAYMENT_DOCUMENTS |
Supplier & customer bank accounts | AP_BANK_ACCOUNTS_ALL | IBY_EXTERNAL_PAYEES_ALL IBY_EXT_BANK_ACCOUNTS IBY_PMT_INSTR_USES_ALL |
Suppliers & TCA
Supplier, supplier site, & supplier contact information migrated to TCA tables
• Three new AP tables containing supplier unique data, with links to TCA tables
AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS
• Three old PO Vendors tables obsolete
– Views provided for backward compatibility
Supplier Changes
Co-existing Tables
Release 12 Payables | R12 | |
Suppliers | AP_SUPPLIERS | HZ_PARTIES |
Supplier sites | AP_SUPPLIER_SITES_ALL | HZ_PARTY_SITES HZ_LOCATIONS |
Supplier contacts | AP_SUPPLIER_CONTACTS | HZ_PARTIES HZ_PARTY_SITES HZ_RELATIONSHIPS HZ_ORG_CONTACTS |
Obsolete Tables
11i | R12 | |
Suppliers | PO_VENDORS | AP_SUPPLIERS |
Supplier sites | PO_VENDOR_SITES_ALL | AP_SUPPLIER_SITES_ALL |
Supplier contacts | PO_VENDOR_CONTACTS | AP_SUPPLIER_CONTACTS |
Banks Data in R12
Setup in Cash Management (CE)
– Bank, bank account setup
– Shared with Payables, Receivables, Treasury, & Payroll
• Banks & bank branches now represented as TCA parties
– 11i AP bank data moved to TCA HZ_PARTIES table
• Three key CE tables
– CE_BANK_ACCOUNTS for bank accounts
– CE_BANK_ACCT_USES_ALL for account uses by Operating Units & Legal Entities
– CE_GL_ACCOUNTS_CCID for bank account use accounting data
Bank Data in TCA
Release 12 TCA | |
Bank, bank branch, account attributes, contact persons | HZ_PARTIES |
Bank sites & locations | HZ_PARTY_SITES HZ_LOCATIONS |
Change history & additional attributes | HZ_ORGANIZATION_PROFILES |
Contact details & methods | HZ_CONTACT_POINTS |
Contact titles | HZ_ORG_CONTACT |
Contact purpose or role | HZ_ORG_CONTACT_ROLES |
