Sunday, October 4, 2009

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

Thanks & Regards,
Anto Joe Natesh I

1 comment:

Anonymous said...

Thank you very much...Neeraj!
www.linkedin.com