Migrating Reports to Release 12 - Co-Existing & Obsolete Table details
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
|
No comments:
Post a Comment