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