Mandatory Changes
TCA model based Changes
Receivable module based views
used to populate the customer and contact information has been replaced with
direct references to tables under in Trading Community Architecture (TCA).
|
Object Name
|
:
|
AR_CUSTOMER_PROFILES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
Not able to query this table in
APPS database. Able to describe it. It is a view in older version
|
|
Alternate Solution
|
:
|
In
R12, The following Trading Community Architecture (TCA) tables used to get
the customer contact information’s instead of using AR_CUSTOMER_PROFILES.
à HZ_CUSTOMER_PROFILES
|
|
Object Name
|
:
|
PO_VENDORS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
It is a table in older version
|
|
Alternate Solution
|
:
|
In
R12, PO_VENDORS is a view that joins the AP_SUPPLIERS and HZ_PARTIES.
The following are the list of
Join Conditions
·
AP_SUPPLIERS.party_id
= HZ_PARTIES.party_id
|
|
Object Name
|
:
|
RA_ADDRESSES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
This table does not have data
|
|
Alternate Solution
|
:
|
In
R12, The following Trading Community Architecture (TCA) tables used to get
the customer contact information’s instead of using RA_ADDRESSES_ALL
à HZ_PARTY_SITES
à HZ_LOCATIONS
à HZ_CUST_ACCT_SITES_ALL
The following are the list of Join
Conditions
·
HZ_CUST_ACCCT_SITES_ALL.party_site_id
= HZ_PARTY_SITES.party_site_id
·
HZ_LOCATIONS.location_id
= HZ_PARTY_SITES.location_id
|
|
Object Name
|
:
|
RA_CONTACTS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
It is a view in older version.
This table does not have data
|
|
Alternate Solution
|
:
|
In
R12, The following Trading Community Architecture (TCA) tables used to get
the customer contact information’s instead of using RA_CONTACTS.
à HZ_PARTIES
à HZ_PARTY_RELATIONSHIPS
à HZ_CUST_ACCCOUNT_ROLES
The following are the list of Join
Conditions
·
HZ_CUST_ACCCOUNT_ROLES.party_id
= HZ_PARTY_RELATIONSHIPS.party_id
·
HZ_CUST_ACCOUNT_ROLES.role_type
= ‘CONTACT’
·
HZ_PARTIES.party_id = HZ_PARTY_RELATIONSHIPS.subject_id
|
|
Object Name
|
:
|
RA_CONTACT_ROLES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
It is a view in older version.
This table does not have data.
|
|
Alternate Solution
|
:
|
In R12, The following Trading
Community Architecture (TCA) tables used to get the customer contact role
information’s instead of using RA_CONTACT_ROLES.
à HZ_ROLE_RESPONSIBILITY
|
|
Object Name
|
:
|
RA_CUSTOMERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
It is a view in older version.
This table does not have data.
|
|
Alternate Solution
|
:
|
In R12,
The following Trading Community Architecture (TCA) tables used to get the
customer information’s instead of using RA_CUSTOMERS.
à HZ_PARTIES
à HZ_CUST_ACCOUNTS
The link between two tables is
HZ_PARTIES.PARTY_ID and HZ_CUST_ACCOUNTS.PARTY_ID.
|
|
Object Name
|
:
|
CE_SYSTEM_PARAMETERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
It is a view in existing version and also added “_OLD” in
existing one or more columns. In R12, 8 more additional columns are added in
this table.
|
|
Object Name
|
:
|
RA_PHONES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
It is
a view in older version. This table does not have data.
|
|
Alternate Solution
|
:
|
In R12,
The following Trading Community Architecture (TCA) tables used to get the
customer communication information’s instead of using RA_PHONES.
à HZ_CONTACT_POINTS
|
|
Object Name
|
:
|
RA_SITE_USES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
This table
does not have data.
|
|
Alternate Solution
|
:
|
In R12,
The following Trading Community Architecture (TCA) tables used to get the
customer site information’s instead of using RA_SITE_USES_ALL.
à HZ_CUST_SITE_USES_ALL
|
|
Object Name
|
:
|
RA_SITE_USES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
This
table does not have data.
|
|
Alternate Solution
|
:
|
In R12,
The following Trading Community Architecture (TCA) table used to get the
customer site information’s instead of using RA_SITE_USES_ALL.
à HZ_CUST_SITE_USES_ALL
|
Column renamed in R12
In R12, Some of the mandatory table
column names are renamed. For Example, GL_BALACES table “SET_OF_BOOK_ID” column
name has been renamed as “LEDGER_ID”.
|
Object Name
|
:
|
GL_BALANCES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “SET_OF_BOOK_ID” has
been renamed as “LEDGER_ID”.
|
|
Object Name
|
:
|
GL_INTERFACE
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “SET_OF_BOOK_ID” column
value has been restored in “LEDGER_ID” and “SET_OF_BOOK_ID” does not have
proper value. 4 additional columns are added in this table.
|
|
Object Name
|
:
|
GL_JE_BATCHES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “SET_OF_BOOK_ID” has been renamed as
“SET_OF_BOOK_ID_11I”. 26 additional columns are added in this table.
|
|
Object Name
|
:
|
GL_JE_HEADERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “SET_OF_BOOK_ID” has
been renamed as “LEDGER_ID”. 8 additional columns are added in this table.
|
|
Object Name
|
:
|
GL_PERIOD_STATUSES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “SET_OF_BOOK_ID” column
value has been restored in LEDGER_ID” and “SET_OF_BOOK_ID” also have proper
value. 3 additional columns are added in this table.
|
Objects removed in R12
The following objects have been removed in
R12.
|
Object Name
|
:
|
AP_BANK_ACCOUNT_USES_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
This view does not exist in
R12.
|
|
Alternate Solution
|
:
|
This
view is based on AP_BANK_ACCOUNT_USES_ALL table. The table
AP_BANK_ACCOUNT_USES_ALL has been replaced by the table CE_BANK_ACCT_USES_ALL
in R12.
|
|
Object Name
|
:
|
PO_ACCRUAL_RECONCILE_TEMP
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
This
view does not exist in R12.
|
|
Alternate Solution
|
:
|
This
view is based on PO_ACCRUAL_RECONCILE_TEMP_ALL table. The table PO_ACCRUAL_RECONCILE_TEMP_ALL has been replaced by
the tables CST_RECONCILIATION_SUMMARY and CST_AP_PO_RECONCILIATION in
R12.
|
|
Object Name
|
:
|
PO_DISTRIBUTIONS_MRC_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
This view does not exist in
R12.
|
|
Alternate Solution
|
:
|
This view
is based on following tables PO_DISTRIBUTIONS_ALL and PO_MC_DISTRIBUTIONS.
The following are the list
of Join Conditions
PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = PO_MC_DISTRIBUTIONS.PO_DISTRIBUTION_ID
|
|
Object Name
|
:
|
PO_HEADERS_MRC_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
This view does not exist in
R12.
|
|
Alternate Solution
|
:
|
This view
is based on following tables PO_HEADERS_ALL and PO_MC_HEADERS.
The following are the list
of Join Conditions
PO_HEADERS_ALL.PO_HEADER_ID= PO_MC_HEADERS.PO_HEADER_ID
|
|
Object Name
|
:
|
RA_SITE_USES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
This view does not exist in
R12.
|
|
Alternate Solution
|
:
|
In R12,
The HZ_CUST_SITE_USES_ALL
table is used to get the customer site information’s instead of using
RA_SITE_USES.
|
MOAC Based Changes in R12
|
Object Name
|
:
|
AP_AE_HEADERS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12,“ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
AP_BANK_ACCOUNTS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “AP_BANK_ACCOUNTS” it is directly pointing to “AP_BANK_ACCOUNTS_ALL” table.
|
|
Object Name
|
:
|
AP_BANK_ACCOUNTS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, “ORG_ID” default value has been removed which is used to populate the
“CLIENT_INFO” value. 2 more additional columns are added in this table.
|
|
Object Name
|
:
|
AP_BANK_ACCOUNT_USES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “AP_BANK_ACCOUNT_USES” it is directly pointing to “AP_BANK_ACCOUNT_USES_ALL” table.
|
|
Object Name
|
:
|
AP_CHECKS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 20 additional columns are added in this table. “ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
AP_HOLDS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 4 additional columns are added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
AP_INVOICES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 60 additional columns are added in this table. “ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
AP_INVOICES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 60 additional columns are added in this table. “ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
AP_INVOICE_DISTRIBUTIONS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 57 additional columns are added in this
table. “ORG_ID” default value has been removed which is used to populate the
“CLIENT_INFO” value.
|
|
Object Name
|
:
|
AP_TAX_CODES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
AR_BATCHES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value. 2 more additional columns
are added in this table.
|
|
Object Name
|
:
|
AR_BATCH_SOURCES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value. 1
additional column is added in this table.
|
|
Object Name
|
:
|
AR_CASH_RECEIPTS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “AR_CASH_RECEIPTS” it is directly pointing to “AR_CASH_RECEIPTS_ALL” table.
|
|
Object Name
|
:
|
AR_CASH_RECEIPTS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value. 18 more additional columns
are added in this table.
|
|
Object Name
|
:
|
AR_PAYMENT_SCHEDULES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “AR_PAYMENT_SCHEDULES” it is directly pointing to “AR_PAYMENT_SCHEDULES_ALL” table. 6 additional
columns are added in this table.
|
|
Object Name
|
:
|
AR_VAT_TAX_ALL_B
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value. 5 more additional columns
are added in this table.
|
|
Object Name
|
:
|
HZ_CUST_SITE_USES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “HZ_CUST_SITE_USES” it
is directly pointing to “HZ_CUST_SITE_USES_ALL” table. “ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value
|
|
Object Name
|
:
|
PO_ACCRUAL_ACCOUNTS_TEMP
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_ACCRUAL_ACCOUNTS_TEMP”
it is directly pointing to “PO_ACCRUAL_ACCOUNTS_TEMP_ALL”
table. It is a view in older version.
|
|
Object Name
|
:
|
PO_ACCRUAL_WRITE_OFFS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_ACCRUAL_WRITE_OFFS” it is directly pointing to
“PO_ACCRUAL_WRITE_OFFS_ALL” table. It is a
view in older version.
|
|
Object Name
|
:
|
PO_DISTRIBUTIONS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_DISTRIBUTIONS” it
is directly pointing to “PO_DISTRIBUTIONS _ALL” table.
|
|
Object Name
|
:
|
PO_DISTRIBUTIONS _ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 18 additional columns
are added in this table. “ORG_ID” default value has been removed which is
used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_HEADERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_HEADERS” it is
directly pointing to “PO_HEADERS_ALL” table.
|
|
Object Name
|
:
|
PO_HEADERS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 22 additional columns
are added in this table. “ORG_ID” default value has been removed which is
used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_LINES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_LINES” it is
directly pointing to “PO_LINES_ALL” table.
|
|
Object Name
|
:
|
PO_LINES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 26 additional columns
are added in this table. “ORG_ID” default value has been removed which is
used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_LINE_LOCATION
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_LINE_LOCATION” it is directly pointing to “PO_LINE_LOCATION_ALL” table.
|
|
Object Name
|
:
|
PO_LINE_LOCATIONS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 21 additional columns
are added in this table. “ORG_ID” default value has been removed which is
used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_LOCATION_ASSOCIATIONS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_LOCATION_ASSOCIATIONS” it is directly pointing
to “PO_LOCATION_ASSOCIATIONS_ALL” table. It
is a view in older version.
|
|
Object Name
|
:
|
PO_RELEASES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_RELEASES” it is directly pointing to “PO_RELEASES_ALL” table.
|
Object Name
|
:
|
PO_RELEASES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 4 additional columns are added in this table. “ORG_ID” default
value has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_REQUISITIONS_INTERFACE
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_REQUISITIONS_INTERFACE” it is directly pointing
to “PO_REQUISITIONS_INTERFACE_ALL” table.
|
|
Object Name
|
:
|
PO_REQUISITIONS_INTERFACE_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 2 additional columns are added in this table.. “ORG_ID” default
value has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_REQUISITION_HEADERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_REQUISITION_HEADERS” it is directly pointing to
“PO_REQUISITION_HEADERS_ALL” table.
|
|
Object Name
|
:
|
PO_REQUISITION_HEADERS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 16 additional columns are added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_REQUISITION_LINES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_REQUISITION_LINES” it is directly pointing to “PO_REQUISITION_LINES_ALL” table.
|
|
Object Name
|
:
|
PO_REQUISITION_LINES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 45 additional columns are added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_REQ_DISTRIBUTIONS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_REQ_DISTRIBUTIONS” it is directly pointing to “PO_REQ_DISTRIBUTIONS_ALL” table.
|
|
Object Name
|
:
|
PO_REQ_DISTRIBUTIONS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 1 additional column is added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
PO_SYSTEM_PARAMETERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “PO_SYSTEM_PARAMETERS” it is directly pointing to “PO_SYSTEM_PARAMETERS_ALL” table.
|
|
Object Name
|
:
|
PO_SYSTEM_PARAMETERS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 5 additional columns are added in this table. “ORG_ID” default value has
been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
RA_BATCH_SOURCES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 3 additional columns are added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
RA_CUSTOMER_TRX
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “RA_CUSTOMER_TRX” it is directly pointing to “RA_CUSTOMER_TRX_ALL” table.
|
|
Object Name
|
:
|
RA_CUSTOMER_TRX_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 14 additional columns are added in this table. “ORG_ID” default value
has been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
RA_CUSTOMER_TRX_LINES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “RA_CUSTOMER_TRX_LINES” it is directly pointing to
“RA_CUSTOMER_TRX_LINES_ALL” table.
|
|
Object Name
|
:
|
RA_CUSTOMER_TRX_LINES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 15 additional columns are added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
RA_CUST_TRX_TYPES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, “RA_CUST_TRX_TYPES” it is directly pointing to “RA_CUST_TRX_TYPES_ALL” table.
|
|
Object Name
|
:
|
RA_CUST_TRX_TYPES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 3 additional columns are added in this table. “ORG_ID” default value has
been removed which is used to populate the “CLIENT_INFO” value.
|
|
Object Name
|
:
|
RA_INTERFACE_LINES_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In
R12, 37 additional columns are added in this table. “ORG_ID” default value has been removed
which is used to populate the “CLIENT_INFO” value.
|
Optional Changes
Additional Column(s) added to Objects in R12
In
part upgrade Oracle introduced one or more new columns in following Objects.
|
Object Name
|
:
|
AP_HOLD_CODES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 5 additional columns
are added in this table.
|
|
Object Name
|
:
|
AP_INVOICES_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 60± additional columns
are added in this view.
|
|
Object Name
|
:
|
AR_AUTOREC_EXCEPTIONS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 1 additional column is
added in this table.
|
|
Object Name
|
:
|
AR_CASH_RECEIPTS_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 6 additional columns
are added in this view.
|
|
Object Name
|
:
|
AR_LOCATION_RATES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
It is a table in older version.
|
|
Object Name
|
:
|
AR_LOCATION_VALUES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
It is a table in older version
and also has more columns.
|
|
Object Name
|
:
|
AR_RECEIPT_METHODS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 1 additional column is
added in this table.
|
|
Object Name
|
:
|
CE_STATEMENT_HEADERS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
It is a view in existing
version. In R12, 21 more additional columns are added in this table.
|
|
Object Name
|
:
|
CE_STATEMENT_LINES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 23 additional columns
are added in this table.
|
|
Object Name
|
:
|
CE_STATEMENT_RECONCILIATIONS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 2 additional columns
are added in this view.
|
|
Object Name
|
:
|
GL_CODE_COMBINATIONS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 2 additional columns
are added in this table.
|
|
Object Name
|
:
|
GL_JE_CATEGORIES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 1 additional column is
added in this table.
|
|
Object Name
|
:
|
GL_SETS_OF_BOOKS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
It is a table in existing
version.
|
|
Object Name
|
:
|
HR_EMPLOYEES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 1 additional column is
added in this view.
|
|
Object Name
|
:
|
HR_EMPLOYEES_CURRENT_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 1 additional column is
added in this view.
|
|
Object Name
|
:
|
HR_LOCATIONS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 1 additional column is
added in this view.
|
|
Object Name
|
:
|
HR_ORGANIZATION_UNITS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 10 additional columns
are added in this view.
|
|
Object Name
|
:
|
HR_ORGANIZATION_UNITS_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 10 additional columns
are added in this view.
|
|
Object Name
|
:
|
MTL_ITEM_STATUS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
It is a table in older version.
|
|
Object Name
|
:
|
MTL_ONHAND_QUANTITIES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 3 additional columns are added in this view.
|
|
Object Name
|
:
|
MTL_SYSTEM_ITEMS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 63 additional columns
are added in this table.
|
Object Name
|
:
|
PER_ABSENCE_ATTENDANCES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 5 additional columns
are added in this table
|
|
Object Name
|
:
|
PER_ABSENCE_ATTENDANCE_TYPES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 26 additional columns
are added in this table.
|
|
Object Name
|
:
|
PO_BUYERS_ALL_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 5 additional columns
are added in this view
|
|
Object Name
|
:
|
PO_DISTRIBUTIONS_AP_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In R12, 8 additional columns
are added in this view.
|
|
Object Name
|
:
|
PO_DISTRIBUTIONS_INTERFACE
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 4 additional columns
are added in this table.
|
|
Object Name
|
:
|
PO_HEADERS_INTERFACE
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 8 additional columns
are added in this table.
|
|
Object Name
|
:
|
PO_HEADERS_PRINT
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 2 additional columns are added in this view.
|
|
Object Name
|
:
|
PO_INTERFACE_ERRORS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 18 additional columns
are added in this table.
|
|
Object Name
|
:
|
PO_LINES_INTERFACE
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 18 additional columns
are added in this table.
|
|
Object Name
|
:
|
PO_LINES_PRINT
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 2 additional columns are added in this view.
|
|
Object Name
|
:
|
PO_LINES_RFQQT_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 1 additional column is added in this view.
|
|
Object Name
|
:
|
PO_LINE_LOCATIONS_PRINT
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 1 additional column is added in this view.
|
|
Object Name
|
:
|
PO_LINE_LOCATIONS_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 3 additional columns are added in this view.
|
|
Object Name
|
:
|
PO_POS_ALL_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 2 additional columns are added in this view.
|
|
Object Name
|
:
|
PO_POS_VAL_V
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 1 additional column is added in this view.
|
|
Object Name
|
:
|
PO_VENDOR_CONTACTS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 7 additional columns are added in this table. It is a table in older
version.
|
|
Object Name
|
:
|
RA_SALESREPS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
In R12, 37 additional columns
are added in this table. It is directly pointing to
JTF_RS_SALESREPS table.
|
|
Object Name
|
:
|
RA_TERMS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
In
R12, 2 additional columns are added in this view.
|
No change in Objects
The
following objects do not have any impact on the new upgrade (R12).
|
Object Name
|
:
|
AP_BANK_BRANCHES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
AP_CHECK_FORMATS
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
AR_AGING_BUCKET_LINES
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
AR_LOOKUPS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
AR_SALES_TAX
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
FND_APPLICATION
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
FND_COMMON_LOOKUPS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
FND_CURRENCIES_VL
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
FND_FLEX_VALUES_VL
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
FND_FLEX_VALUE_NORM_HIERARCHY
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
HR_LOOKUPS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
MTL_CATEGORIES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
MTL_CATEGORY_SETS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
ORG_FREIGHT
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
ORG_ORGANIZATION_DEFINITIONS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
PO_EMPLOYEE_HIERARCHIES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
PO_LOOKUP_CODES
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
PO_POSITION_CONTROLS_ALL
|
|
Object Type
|
:
|
Table
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
RCV_ROUTING_HEADERS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
FND_FLEX_VALUES_VL
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
|
Object Name
|
:
|
PO_UN_NUMBERS
|
|
Object Type
|
:
|
View
|
|
Changes
|
:
|
No Changes required.
|
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.