Description:

In this article, I am going to cover minimum database object level changes done by Oracle in the upgrade like object obsolete, package level changes, API changes.

Accounts Payable

11i R12
PO_VENDORS AP_SUPPLIERS
PO_VENDOR_SITES_ALL AP_SUPPLIER_SITES_ALL
PO_VENDOR_CONTACTS AP_SUPPLIER_CONTACTS
AP_SUPPLIER_INT_REJECTIONS
AP_INVOICE_LINES_ALL

IBY Payment

11i R12
IBY_PAY_SERVICE_REQUESTS
IBY_PAY_INSTRUCTIONS_ALL
IBY_DOCS_PAYABLE_ALL
IBY_PAYMENTS_ALL
IBY_EXTERNAL_PAYEES_ALL
IBY_EXT_BANK_ACCOUNTS
IBY_EXT_PARTY_PMT_MTHDS
IBY_ACCOUNT_OWNERS
IBY_PMT_INSTR_USES_ALL

Accounting

11i R12
AP_ACOCUNTING_EVENTS_ALL XLA_EVENTS
AP_AE_HEADERS_ALL XLA_AE_HEADERS
AP_AE_LINES_ALL XLA_AE_LINES
XLA_DISTRIBUTION_LINKS

General Ledger

11i R12
GL_SETS_OF_BOOKS GL_LEDGERS

Bank Accounts

11i R12
AP_BANKS CE_BANKS
AP_BANK_BRANCHES CE_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL CE_BANK_ACCOUNTS
AP_BANK_ACCOUNT_USES_ALL CE_BANK_ACCT_USES_ALL
AP_CHECK_STOCKS_ALL CE_PAYMENT_DOCUMENTS
CE_GL_ACCOUNTS_CCID

TCA

HZ_PARTIES
HZ_PERSON_PROFILES
HZ_PARTY_RELATIONSHIPS
HZ_LOCATIONS
HZ_LOCATION_PROFILES
HZ_PARTY_SITES
HZ_PARTY_SITE_USES
HZ_RELATIONSHIPS
HZ_ORG_CONTACTS
HZ_CONTACT_POINTS
HZ_CUST_ACCOUNTS
HZ_CUST_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL

-Eswaramoorthi

Summary:

This changes will actually cover 80% of the changes for Order Management, Distribution type of Oracle Apps Implementation in 11i and R12 changes.

Queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.

Recent Posts

Start typing and press Enter to search