New Tables
|
Table Names
|
Feature Area
|
|
CE_BANK_ACCOUNTS
|
Internal
Bank Accounts
|
|
CE_PAYMENT_DOCUMENTS
|
Payment
Documents to be used for Printed type Payments
|
|
IBY_EXTERNAL_PAYEES_ALL
|
Payee
(Trading Partner Info for paying invoices
|
|
IBY_PMT_INSTR_USES_ALL
|
Used
for Remit to Bank Accounts
|
|
AP_INVOICE_LINES_ALL
|
Invoice
Lines
|
|
AP_ALLOCATION_RULES
|
Invoice
Lines
|
|
AP_INVOICE_LINES_ALL
|
Invoice
Lines
|
|
AP_ALLOCATION_RULES
|
Invoice
Lines
|
|
AP_ALLOCATION_RULE_LINES
|
Invoice
Lines
|
|
AP_ALLOCATION_RULE_LINES_GT
|
Global
Temp Table for Invoice Lines – Allocations
|
|
AP_SELF_ASSESSED_TAX_DIST_ALL
|
E-Business
Tax
|
|
AP_PRODUCT_REGISTRATIONS
|
Invoice
Lines
|
|
AP_PRODUCT_SETUP
|
Multi
Org Access Control
|
|
AP_TOLERANCE_TEMPLATES
|
Support
of complex PO Contracts
|
|
AP_NEGOTIATION_HIST
|
Invoice
Requests
|
|
AP_NEGOTIATION_HIST
|
Holds
Resolution Workflow
|
|
Table Name
|
Feature Area
|
Brief Description of Change
|
|
AP_INVOICES_ALL
|
Invoice
Lines, eBusiness Tax, Payments, SLA, Complex Work POs…
|
Number
of columns were added to this table
due to almost all the projects done for R12, for list of columns added please
refer to the TDD of the respective projects.
|
|
AP_INVOICE_DISTRIBUTIONS_ALL
|
Invoice
Lines, eBusiness Tax…
|
Number
of columns were added to this table due to almost all the projects done for
R12, for list of columns added please refer to the TDD of the respective
projects.
|
|
AP_INV_APRVL_HIST_ALL
|
Holds
resolution workflow
|
Hold_ID
column was added.
|
|
AP_CHECKS_ALL
|
Payables
Payments Data
|
Some
new columns are added to AP_CHECKS_ALL table for maintaining real time
synchronization with Oracle Payments and Cash Managements. Some existing
columns from the same tables have been made obsolete.
|
|
AP_HOLDS_ALL
|
Holds
Resolution Workflow
|
New
Columns Added were: Hold_id and wf_status.
|
|
AP_HOLD_CODES
|
Holds
Resolution Workflow
|
New
Columns Added were: hold_instruction, wait_before_notify_days, reminder_days
|
|
AP_INV_APRVL_HIST_ALL
|
Holds
Resolution and Invoice Approval Workflow
|
This
will be used to record history for both the Invoice level Approvals and
Invoice Line level approvals. New Columns Added were:line_number, hold_id and
history_type
|
|
AP_APINV_APPROVERS
|
Invoice
Approval Workflow
|
New
Columns Added were:child_process_item_key, child_process_item_type, item_type
and item_key.
|
|
Table Name
|
Feature Area
|
Replaced By
|
|
AP_BANK_BRANCHES
|
Bank/Bank
Branches
|
CE_BANK_BRANCHES_V
|
|
AP_BANK_ACCOUNTS_ALL
|
Bank
Accounts including Internal and External
|
CE_BANK_USES_OU_V/IBY_EXT_BANK_ACCOUNTS_V
|
|
AP_BANK_ACCOUNTS_USES_ALL
|
Remit
to Bank Account Uses
|
|
|
AP_CHECK_STOCKS_ALL
|
Payments
Documents
|
CE_PAYMENT_DOCUMENTS
|
|
AP_CHECK_FORMATS
|
Payments
Format
|
|
|
AP_TAX_RECVRY_RULES_ALL
|
EBusiness
Tax
|
Replaced
by relevant EBTax tables/views.
|
|
AP_TAX_RECVRY_RATES_ALL
|
EBusiness
Tax
|
Replaced
by relevant EBTax tables/views.
|
|
AP_CHRG_ALLOCATIONS_ALL
|
Invoice
Lines - Allocations
|
This
feature is replaced by distributions itself, distributions itself represent
the allocation of charges.
|
|
AP_TAX_DERIVATIONS
|
EBusiness
Tax
|
Replaced
by relevant EBTax tables/views.
|
|
AP_LINE_APRVL_HIST_ALL
|
Invoice
Approval Workflow
|
AP_INV_APRVL_HIST_ALL
|
|
View Name
|
Feature Area
|
|
CE_BANK_BRANCHES_V
|
Bank/Branches
Info
|
|
CE_BANK_ACCT_USES_OU_V
|
Internal
Bank Account Uses Info
|
|
IBY_EXT_BANK_ACCOUNTS_V
|
Remit
to Bank Account Info
|
|
AP_DOCUMENTS_PAYABLE
|
This
view will store interim payables check and payment schedules information.
Based on this view Oracle Payments will process data for formatting and
building payment. As described in the “Single Payment real-time Flow”
diagrams this view will store real time payables data. As a result of this
until or unless payment is created, this view will not contain any data for
quick payments.
|
|
AP_INVOICE_LINES_V
|
Invoice
Lines project. This is the base view for the Lines block on invoice
workbench.
|
|
AP_PO_CORRECTIONS_V
|
PO
Corrections.
|
|
AP_MATCH_CORRECTION_DISTS_V
|
Distribution
level PO/RCV Corrections.
|
|
AP_RECEIPT_CORRECTIONS_V
|
Receipt
Corrections.
|
|
AP_ALLOCATION_RULES_V
|
Invoice
Lines - Allocations.
|
|
View Name
|
Feature Area
|
|
AP_INVOICES_V
|
All
the columns that were added to the base table due to the various projects
were added to this view too.
|
|
AP_INVOICE_DISTRIBUTIONS_V
|
All
the columns that were added to the base table due to the various projects
were added to this view too.
|
|
PO_LINE_LOCATIONS_AP_V
|
PO
Matching
|
|
AP_PO_DISTRIBUTIONS_AP2_V
|
PO
Matching at distribution level.
|
|
PO_AP_RECEIPT_MATCH_V
|
Receipt
Matching view
|
|
AP_APPLY_PREPAYS_V
|
Invoice
Lines – Prepayment Application
|
|
AP_UNAPPLY_PREPAYS_V
|
Invoice
Lines – Prepayment Application
|
|
AP_WF_APPROVAL_HISTORY_V
|
Invoice
Approval Workflow
|
|
View Name
|
Feature Area
|
|
AP_BANK_ACCOUNTS
|
Internal/External
Bank Accounts Multi-Org View
|
|
AP_BANK_ACCOUNT_USES
|
External
Bank Account Uses Multi-Org View
|
|
AP_BANK_ACCOUNT_USES_V
|
External
Bank Accounts Uses Reference View
|
The following are
the new tables added in Release 12 as a part of this initiative.
Refer to the Oracle E-Business Suite Electronic Technical Reference Manual for the table and column descriptions..
· AP_SUPPLIERS
· AP_SUPPLIER_SITES_ALL
· AP_SUPPLIER_CONTACTS
· AP_SUPPLIER_INT_REJECTIONS
New
Views
The following are
the new views added in Release 12 as a part of this initiative.
These are backwards compatible views that join the Suppliers table in Payables and the TCA tables,
so that any teams using the old suppliers tables have no impact.
· PO_VENDORS
· PO_VENDOR_SITES_ALL
· PO_VENDOR_CONTACTS
The following tables are obsoleted:
· PO_VENDORS
· PO_VENDOR_SITES_ALL
· PO_VENDOR_CONTACTS
New
Tables
Description of Change
AR_REC_TRX_LE_DETAILS_ALL
Added detail
level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a
receivables activity and the sets of asset and liability tax codes by legal
entity.
AR_DEFERRAL_REASONS
Revenue Deferral
Reasons
AR_DEFERRED_LINES_ALL
Revenue Deferral
Reasons
AR_RDR_PARAMETERS_GT
Revenue Deferral
Reasons
AR_REVIEWED_LINES_GT
Revenue Deferral
Reasons
Changed Tables
Table Name Description of Change
RA_CUSTOMER_TRX_LINES_ALL
Added numerous
columns to support E-Business Tax and line-level Ship To, Added Payment
extension identifier.
AR_MEMO_LINES
Added
tax_product_category to support E-Business Tax uptake.
AR_TRX_LINES_GT
Added numerous
columns to support E-Business Tax uptake, Added parent_line_id and
deferral_exclusion_flag.
AR_TRX_LINES_TMP_GT
Added numerous
columns to support E-Business Tax uptake, Added parent_line_id and
deferral_exclusion_flag.
AR_ARCHIVE_DETAIL
Added numerous
columns to support E-Business Tax and line-level Ship To,
RA_BATCH_SOURCES_ALL
Obsoleted
invalid_tax_rate_rule column.
HZ_CUST_SITE_USES
Migrated
tax_code, tax_header_level_flag, tax_reference, and tax_classification to
ZX_PARTY_TAX_PROFILE and ZX_REGISTRATIONS tables.
ZX_PARTY_TAX_PROFILE and ZX_REGISTRATIONS tables.
AR_CASH_RECEIPTS_ALL
Added Payment
extension identifier and obsoleted, approval_code,
address_verification_code,
payment_server_order_num, Renamed column REMITTANCE_BANK_ACCOUNT_ID to
REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
AR_RECEIPT_METHODS
Added Payment
Channel Code and obsoleted, payment_type_code, merchant_ref, merchant_id,
auto_print_program_id
RA_CUSTOMER_TRX_ALL
Added Payment
extension identifier and Payment Attributes,
obsoleted
payment_server_order_num, approval_code, address_verification_code, Renamed
column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added
legal_entity_id column.
RA_INTERFACE_LINES_ALL
Added Payment
extension identifier and Payment Attributes, and obsoleted
payment_server_order_num, approval_code, address_verification_code, Added
legal_entity_id column, Added parent_line_id and deferral_exclusion_flag.
AR_AUTOREC_EXCEPTIONS
Renamed column
REMIT_BANK_ACCT_ID to REMIT_BANK_ACCT_USE_ID
AR_BATCHES_ALL
Renamed column
REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_BATCH_SOURCES_ALL
Renamed column
DEFAULT_REMIT_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_INTERIM_CASH_RECEIPTS_ALL
Renamed column
REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_RECEIPT_METHOD_ACCOUNTS_ALL
Renamed column
BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_TRX_HEADER_GT
Added
legal_entity_id column
AR_TRX_HEADER_TMP_GT
Added
legal_entity_id column
AR_LINE_CONTS_ALL
Added
contingency_id as a foreign key to AR_DEFERRAL_REASONS
AR_TRX_CONTINGENCIES_GT
Added
contingency_id, expiration_event_date and completed_flag.
Obsolete Tables
Table Name
AR_TA_ASGN_TO_INT_ALL
AR_TA_CASHAPP_OB_ALL
AR_TA_CR_AGEN_INF_ALL
AR_TA_CUST_HIER_CHILD
AR_TA_CUST_HIER_PARNT
AR_TA_CUST_INT_ALL
AR_TA_CUST_TRXSTR_ALL
AR_TA_DEDN_ASSGNS_ALL
AR_TA_DEDN_INT_ALL
AR_TA_DEDN_RELATE_ALL
AR_TA_LEGACY_CUST_INT
AR_TA_LEGACY_STAT_INT
AR_TA_PAYMNT_HIST_ALL
AR_TA_PROF_ASSGNT_ALL
AR_TA_PROMOTIONS_ALL
AR_TA_PROMOTIONS_INT
AR_TA_PROM_CUST_ALL
AR_TA_PROM_CUST_MAP
AR_TA_PROM_LINES_INT
AR_TA_PROM_PAYMNT_ALL
AR_TA_PROM_PAYMNT_TYP
AR_TA_PROM_PRODS_ALL
AR_TA_PROM_STATUS_MAP
AR_TA_RECON_INFO_ALL
AR_TA_RECV_TRXSET_ALL
AR_TA_REMIT_HIST_ALL
AR_TA_REMIT_PROF_ALL
AR_TA_RISK_COMENT_ALL
AR_TA_RULES_ALL
AR_TA_RULE_OUTPUT
AR_TA_RULE_SETS_ALL
AR_TA_RULE_SET_LN_ALL
AR_TA_TRX_SETS_ALL
AR_TA_TRX_SET_LN_ALL
AR_TA_TRX_TO_CREATE
AR_TA_TRX_TYP_INT_ALL
AR_TA_VERSIONS
New Views
View Name
Description of Change
AR_MEMO_LINES_VL
Added
tax_product_category.
AR_SHIP_ADDRESS_V
Removed
hz_loc_assignments.
RA_CUSTOMER_TRX_LINES_V
Added numerous
columns
AR_DOCS_RECEIVABLES_V
AR_FUNDS_CAPTURE_ORDERS_V
ARBR_DOCS_RECEIVABLES_V
ARBR_DOCUMENT_LINES_V
ARBR_FUNDS_CAPTURE_ORDERS_V
AR_CBA_BANK_BRANCH_CONTACTS_V
AR_CBA_BANK_ACCOUNT_CONTACTS_V
AR_CBA_EFT_USER_NUMBER_V
AR_LINE_DEFERRAL_REASONS
Revenue Deferral
Reasons
AR_LINE_CONTINGENCIES_V
Revenue Deferral
Reasons
AR_RDR_ITEMS_V
Reasons,
Validation Set for RDR setup
Changed Views
View Name Description of Change
AR_AUTOMATIC_RECEIPTS_FORMAT_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
AR_BOE_AUTO_RECEIPTS_V
Added Payment
extension identifier to view
AR_BOE_REMIT_RECEIPTS_CBUNR_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
AR_BOE_REMIT_RECEIPTS_NONCBR_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
AR_BOE_REMIT_RECEIPTS_V
Modified the
view to accommodate the data model changes related to payment uptake project
AR_BR_ASSIGNMENTS_V
Modified the
view to accommodate the data model changes related to payment uptake project
AR_BR_MAIN_REMIT_BATCH_V
Modified the
view to accommodate the data model changes related to payment uptake project
AR_CASH_RECEIPTS_V
Added Payment
extension identifier and payment channel identifier to view
AR_CUSTOMER_BILLS_TRX_V
Added Payment
extension identifier and payment channel identifier to view
AR_REMITTED_RECEIPTS_FORMAT_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
RA_CUSTOMER_TRX_CM_V
Modified the
view to accommodate the data model changes related to payment uptake project
Added Payment
extension identifier and the payment channel identifier to view
RA_CUSTOMER_TRX_PART_CB_V
Modified the
view to accommodate the data model changes related to payment uptake project
Added Payment
extension identifier and the payment channel identifier to view
RA_CUSTOMER_TRX_PARTIAL_V
Modified the
view to accommodate the data model changes related to payment uptake project
Added Payment
extension identifier and the payment channel identifier to view
AR_AEL_GL_REC_V
Made changes to
support the new Internal Bank Account data model.
AR_AEL_SL_REC_V
Made changes to
support the new Internal Bank Account data model.
AR_CUSTOMER_BILLS_TRX_V
Made changes to
support the new Internal Bank Account data model.
AR_BR_MAIN_REMIT_BATCH_V
Made changes to
support the new Internal Bank Account data model.
AR_BATCHES_V
Made changes to
support the new Internal Bank Account data model.
AR_BATCH_REMIT_V
Made changes to
support the new Internal Bank Account data model.
AR_BOE_REMIT_RECEIPTS_V
Made changes to
support the new Internal Bank Account data model.
AR_CASH_RECEIPTS_V
Made changes to
support the new Internal Bank Account data model.
AR_INTERIM_CR_LINES_V
Made changes to
support the new Internal Bank Account data model.
AR_CASH_RECEIPTS_V
Added
legal_entity_id column
AR_CUSTOMER_BILLS_TRX_V
Added
legal_entity_id column
AR_PAYMENT_SCHEDULES_PMT_V
Added
legal_entity_id column
AR_PAYMENT_SCHEDULES_TRX2_V
Added
legal_entity_id column
RA_CUSTOMER_TRX_CR_TRX_V
Added
legal_entity_id column
RA_CUSTOMER_TRX_PARTIAL_V
Added
legal_entity_id column
RA_CUSTOMER_TRX_PART_CB_V
Added
legal_entity_id column
AR_PAYMENT_SCHEDULES_V
Added
legal_entity_id column
RA_CUST_TRX_LINE_GL_DIST_V
Added column
user_generated_flag
R 12 TAX CHANGES
Tax
New Tables
Oracle E-Business Tax is a new product in Release 12.
Changed Tables
Table Name Feature Area Brief Description of Change
AP_TAX_CODES_ALL
Oracle Payables Taxes
This table is now used to store only withholding tax codes
AR_VAT_TAX_ALL_B
Oracle Receivables Taxes
This table is
now used only by Latin Tax Engine.
Obsolete Tables
Table Name Feature Area Replaced By
AP_TAX_RECVRY_RATES_ALL
Oracle Payables Taxes
AP_TAX_RECVRY_RULES_ALL
Oracle Payables Taxes
AR_TAX_EXTRACT_DCL_ITF
Tax Reporting Ledger
AR_TAX_EXTR_SUB_AP_EXT
Tax Reporting Ledger
AR_TAX_EXTR_SUB_AR_EXT
Tax Reporting Ledger
AR_TAX_EXTRACT_SUB_ITF
Tax Reporting Ledger
AR_TAX_EXTRACT_MATRIX_ITF
Tax Reporting Ledger
AR_TAX_EXTR_SUB_COM_EXT
Tax Reporting Ledger
AR_LOCATION_COMBINATIONS
Oracle Receivables Taxes
AR_LOCATION_RATES
Oracle Receivables Taxes
AR_LOCATION_VALUES
Oracle Receivables Taxes
AR_SALES_TAX
Oracle Receivables Taxes
AR_SALES_TAX_REP_ITF
Oracle Receivables Taxes
AR_TAX_CONDITION_ACTIONS_ALL
Oracle Receivables Taxes
AR_TAX_CONDITION_LINES_ALL
Oracle Receivables Taxes
AR_TAX_CONDTIONS_ALL
Oracle Receivables Taxes
GL_TAX_OPTIONS
Oracle General Ledger Taxes
GL_TAX_OPTION_ACCOUNTS
Oracle General Ledger Taxes
New Views
Oracle E-Business Tax is a new product in Release 12.
Changed Views
View Name Feature Area Brief Description of Change
GL_TAX_CODES_V
Oracle General Ledger Taxes
This view is modified to return information from the new tax configuration tables of Oracle E-Business Tax.
Obsolete Views
View Name Feature Area Replaced By
AP_TAX_RECVRY_RULES
Oracle Payables Taxes
AP_TAX_RECVRY_RATES
Oracle Payables Taxes
AP_TAX_CODES_NAMES_V
Oracle Payables Taxes
AP_TAX_CODES_V
Oracle Payables Taxes
AP_TAX_LINES_SUMMARY_V
Oracle Payables Taxes
AP_TAX_CODES_VAL_V
Oracle Payables Taxes
AP_TAX_CODES_TN_V
Oracle Payables Taxes
AP_TAX_CODES_ACTIVE_V
Oracle Payables Taxes
AR_TAX_EXTRACT_ITF_V
Tax Reporting Ledger
TAX_LINES_DELETE_V_V
Oracle Receivables Taxes
TAX_LINES_INVOICE_IMPORT_V
Oracle Receivables Taxes
TAX_LINES_DELETE_V
Oracle Receivables Taxes
TAX_LINES_INVOICE_IMPORT_V_A
Oracle Receivables Taxes
TAX_LINES_DELETE_V_A
Oracle Receivables Taxes
TAX_LINES_INQUIRY_V
Oracle Receivables Taxes
TAX_ADJUSTMENTS_V
Oracle Receivables Taxes
OE_TAX_LINES_SUMMARY_V_V
Oracle Receivables Taxes
TAX_LINES_CM_V_A
Oracle Receivables Taxes
AR_DEFAULT_TAX_CODE_V
Oracle Receivables Taxes
AR_CM_DIST_TAX_L_V
Oracle Receivables Taxes
AR_CM_DIST_TAX_L_VL
Oracle Receivables Taxes
AR_CM_TAX_L_V
Oracle Receivables Taxes
TAX_ADJUSTMENTS_V_V
Oracle Receivables Taxes
TAX_LINES_RECREATE_V
Oracle Receivables Taxes
TAX_LINES_CREATE_V_A
Oracle Receivables Taxes
TAX_LINES_RECURR_INVOICE_V
Oracle Receivables Taxes
TAX_LINES_RECURR_INVOICE_V_A
Oracle Receivables Taxes
TAX_LINES_RMA_IMPORT_V_V
Oracle Receivables Taxes
TAX_LINES_CM_V
Oracle Receivables Taxes
TAX_LINES_CREATE_V_V
Oracle Receivables Taxes
AR_TAX_L_V
Oracle Receivables Taxes
AR_CM_TAX_L_VL
Oracle Receivables Taxes
OE_TAX_LINES_SUMMARY_V_A
Oracle Receivables Taxes
TAX_LINES_CREATE_V
Oracle Receivables Taxes
TAX_ADJUSTMENTS_V_A
Oracle Receivables Taxes
TAX_LINES_RMA_IMPORT_V
Oracle Receivables Taxes
TAX_LINES_INVOICE_IMPORT_V_V
Oracle Receivables Taxes
TAX_LINES_CM_V_V
Oracle Receivables Taxes
TAX_LINES_RMA_IMPORT_V_A
Oracle Receivables Taxes
TAX_LINES_RECURR_INVOICE_V_V
Oracle Receivables Taxes
TAX_LINES_ENGINE_REVERSE_V
Oracle Receivables Taxes
AR_TAX_L_VL
Oracle Receivables Taxes
AR_DIST_TAX_L_VL
Oracle Receivables Taxes
R 12
GL CHANGES
Table
Name
Feature
Area
Replaced By
GL_IEA_AUTOGEN_MAP
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_CLEARING_ACCOUNTS
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_IMPORT_REGISTRY
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_INTERFACE
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_RECUR_BATCHES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_RECUR_LINES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_SEGMENT_MAP
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_SEGMENT_RULE_MAP
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_TRANSACTION_LINES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_TRANSACTION_TYPES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_TRANSACTIONS
Global Intercompany System
Advanced Global Intercompany System feature
GL_INTERCOMPANY_ACC_SETS
Global Intercompany System
Advanced Global Intercompany System feature
GL_INTERCOMPANY_ACCOUNTS
Global Intercompany System
Advanced Global Intercompany System feature
GL_MC_BOOK_ASSIGNMENTS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
GL_MC_CONVERSION_RULES
Setup Forms and Programs
GL_JE_INCLUSION_RULES
GL_MC_REPORTING_OPTIONS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
GL_OASIS_FIN_ASSIGNMENTS
Financial Intelligence
GL_OASIS_FIN_ITEMS
Financial Intelligence
GL_OASIS_FIN_METRICS
Financial Intelligence
GL_OPEN_INTERIM
Balances and Related Objects
GL_POSTING_INTERIM
GL_SETS_OF_BOOKS
Setup Forms and Programs
GL_LEDGERS
GL_SHARES_ACTIVITY
Financial Intelligence
GL_SHARES_OUTSTANDING
Financial Intelligence
GL_SYSTEM_SETUP
Setup Forms and Programs
Relevant columns were moved to the GL: Number of formulas to validate for
each MassAllocation batch, GL: Number of formulas to validate for each
Recurring Journal batch and GL: Archive Journal Import Data profile options
GL_TRANSLATION_RATES
Revaluation, Translation and Conversion Rates
GL_DAILY_RATES
RG_DSS_DIM_SEGMENTS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_DIMENSIONS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_HIERARCHIES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_HIERARCHY_DETAILS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_REQUESTS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SEG_RANGE_SETS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SEG_RANGES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SYSTEM_SEG_ORDER
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SYSTEM_VARIABLES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SYSTEMS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VAR_DIMENSIONS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VAR_SELECTIONS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VAR_TEMPLATES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VARIABLES
Financial Analyzer
Enterprise Planning and Budgeting product
New Views
A number of new views have been added to support UIs and processing of new
features. Some of the views are mentioned below.
View Name Feature Area
GL_ACCESS_SET_LEDGERS
Setup Forms and Programs
GL_ALC_LEDGER_RSHIPS_V
Setup Forms and Programs
GL_AUTOREV_CRITERIA_SETS_V
Journal Entry
GL_BUDGET_ASSIGNMENTS_UNIQUE_V
Budgets and Related Objects
GL_BUDORG_BC_OPTIONS_V
Budgets and Related Objects
GL_DEFAS_ASSIGNMENTS_V
Setup Forms and Programs
GL_DEFAS_RESP_ASSIGN_V
Setup Forms and Programs
GL_ENTERED_CURRENCIES_V
Balances and Related Objects
GL_HISTORICAL_RATES_PERIOD_V
Revaluation, Translation and Conversion Rates
GL_JE_LINES_RECON_V
Journal Entry
GL_LEDGER_LE_BSV_SPECIFIC_V
Setup Forms and Programs
GL_LEDGER_LE_V
Setup Forms and Programs
GL_LEDGER_NAMES_V
Setup Forms and Programs
GL_LEDGER_NORM_BSVS_V
Setup Forms and Programs
GL_LEDGER_SET_ASSIGNMENTS_V
Setup Forms and Programs
GL_LEDGER_SET_NORM_ASSIGN_V
Setup Forms and Programs
GL_LEDGER_SETS_V
Setup Forms and Programs
GL_LEDGERS_PUBLIC_ALL_V
Setup Forms and Programs
GL_LEDGERS_PUBLIC_V
Setup Forms and Programs
GL_LEDGERS_V
Setup Forms and Programs
GL_REC_BATCHES_LOV_V
Recurring Journals and Budgets
GL_SECONDARY_LEDGER_RSHIPS_V
Setup Forms and Programs
GL_SETS_OF_BOOKS
Setup Forms and Programs
GL_SUMMARY_BC_OPTIONS_V
Summarization
GL_SUMMARY_TEMPLATES_V
Summarization
GL_TRANSLATION_RATES
Revaluation, Translation and Conversion Rates
Changed Views
All views used to support Discoverer workbooks have been updated as necessary to uptake the data model changes. Views that retrieve balances have been updated as necessary to retrieve entered ledger currency balances. A large number of other views have also been updated to uptake various data model changes. Some changed views are highlighted below.
View Name Feature Area Brief Description of Change
GL_SETS_OF_BOOKS_V
Setup Forms and Programs
Modify to refer to GL_LEDGERS instead of GL_SETS_OF_BOOKS
GL_TAX_CODES_V
Setup Forms and Programs
Modify to uptake new eTax data model
Obsoleted Views
A number of views related to Global Intercompany System and Oracle
Financial Analyzer have been obsoleted. Some other obsolete views are mentioned
below.
View Name Feature Area Replaced By
GL_ALL_JE_CATEGORY_NAME_VIEW
Setup Forms and Programs
GL_ALLOC_BATCHES_ACTIVE_V
MassAllocations, Budgets and Encumbrances
GL_AUTOPOST_OPTIONS_CURRENT_V
Posting
GL_CONS_FLEXFIELD_MAP_HIGH
Consolidation and Eliminations
GL_CONS_FLEXFIELD_MAP_LOW
Consolidation and Eliminations
GL_JE_BATCHES_AP_V
Journal Entry
GL_JE_HEADERS_LOV_V
Journal Entry
GL_MC_BOOKS_ASSIGNMENTS_V
Setup Forms and Programs
GL_MRC_REPORTING_SOB_PROFILE_V
Setup Forms and Programs
GL_PERIOD_STATUSES_REV_BUD_V
Setup Forms and Programs
GL_TRANS_BUDGET_PERIODS_V
Revaluation, Translation and Conversion Rates
GL_TRANS_PERIODS_BSV_V
Revaluation, Translation and Conversion Rates
GL_TRANSLATION_RATES_CURR_V
Revaluation, Translation and Conversion Rates
GL_TRANSLATION_RATES_PERIODS_V
Revaluation, Translation and Conversion Rates
GL_TRANSLATION_RATES_V
Revaluation, Translation and Conversion Rates
GL_TRANSLATION_TRACKING_V
Revaluation, Translation and Conversion Rates
RG_REPORT_STANDARD_AXES_V
Financial Statement Generator
R 12
CASHMANAGEMENT CHANGES
New Tables
Table
Name Feature
Area
CE_BANK_ACCOUNTS
Bank Account Model
CE_BANK_ACCT_USES_ALL
Bank Account Model
CE_GL_ACCOUNTS_CCID
Bank Account Model
CE_INTEREST_BALANCE_RANGES
Balances and Interest Calculation
CE_INTEREST_RATES
Balances and Interest Calculation
CE_INTEREST_SCHEDULES
Balances and Interest Calculation
CE_BANK_ACCT_BALANCES
Balances and Interest Calculation
CE_PROJECTED_BALANCES
Balances and Interest Calculation
CE_INT_CALC_DETAILS_TMP
Balances and Interest Calculation
CE_CASHFLOWS
Bank Account Transfers
CE_CASHFLOW_ACCT_H
Bank Account Transfers
CE_PAYMENT_TRANSACTIONS
Bank Account Transfers
CE_PAYMENT_TEMPLATES
Bank Account Transfers
CE_TRXNS_SUBTYPE_CODES
Bank Account Transfers
CE_XLA_EXT_HEADERS
Subledger Accounting
CE_CONTACT_ASSIGNMENTS
Bank Account Model
CE_AP_PM_DOC_CATEGORIES
Bank Account Model
CE_PAYMENT_DOCUMENTS
Bank Account Model
CE_SECURITY_PROFILES_GT
Bank Account Model
CE_CHECKBOOKS
Bank Account Model
Changed Tables
Table
Name
Feature Area Brief Description of Change
CE_AVAILABLE_TRANSACTIONS_TMP
Bank Statement Reconciliation
Add LEGAL_ENTITY_ID and ORG_ID
CE_STATEMENT_RECONCILS_ALL
Bank Statement Reconciliation
Add LEGAL_ENTITY_ID
CE_ARCH_RECONCILIATIONS_ALL
Bank Statement Reconciliation
Add LEGAL_ENTITY_ID
CE_SYSTEM_PARAMETERS_ALL
System Parameters
Add LEGAL_ENTITY_ID; Add Columns for BAT project
CE_ARCH_HEADERS
Bank Statement
Drop ORG_ID
CE_ARCH_INTERFACE_HEADERS
Bank Statement
Drop ORG_ID; Add more balance columns
CE_ARCH_INTRA_HEADERS
Bank Statement
Drop ORG_ID
CE_INTRA_STMT_HEADERS
Bank Statement
Drop ORG_ID
CE_STATEMENT_HEADERS
Bank Statement
Drop ORG_ID
CE_STATEMENT_HEADERS_INTERFACE
Bank Statement
Drop ORG_ID; Add more balance columns
CE_CASHPOOLS
Cash Leveling
Add LEGAL_ENTITY_ID
CE_PROPOSED_TRANSFERS
Cash Leveling
Add columns for Balance project
CE_LEVELING_MESSAGE
Cash Leveling
Add columns for Balance project
CE_TRANSACTIONS_CODES
Bank Statement
Add Columns for Multi-pass reconciliation feature
CE_STATEMENT_LINES
Bank Statement
Add CASHFLOW_ID
Obsolete Tables
Table
Name
Feature
Area
Replaced By
CE_ARCH_HEADERS_ALL
Bank Statement
CE_ARCH_HEADERS
CE_ARCH_INTERFACE_HEADERS_ALL
Bank Statement
CE_ARCH_INTERFACE_HEADERS
CE_ARCH_INTRA_HEADERS_ALL
Bank Statement
CE_ARCH_INTRA_HEADERS
CE_INTRA_STMT_HEADERS_ALL
Bank Statement
CE_INTRA_STMT_HEADERS
CE_STATEMENT_HEADERS_ALL
Bank Statement
CE_STATEMENT_HEADERS
CE_STATEMENT_HEADERS_INT_ALL
Bank Statement
CE_STATEMENT_HEADERS_INTERFACE
New Views
View
Name
Feature Area
CE_SECURITY_PROFILES_V
Bank Account Model
CE_LE_BG_OU_VS_V
Bank Account Model
CE_BANK_ACCOUNTS_V
Bank Account Model
CE_BANK_BRANCHES_V
Bank Account Model
CE_BANK_ACCT_USES
Bank Account Model
CE_BANK_ACCTS_GT_V
Bank Account Model
CE_BANK_ACCT_USES_BG_V
Bank Account Model
CE_BANK_ACCT_USES_LE_V
Bank Account Model
CE_BANK_ACCT_USES_OU_V
Bank Account Model
CE_BANK_ACCTS_CALC_V
Balances and Interests Calculation
CE_INTEREST_RATES_V
Balances and Interests Calculation
CE_260_CF_RECONCILED_V
Bank Statement Reconciliation
CE_260_CF_TRANSACTIONS_V
Bank Statement Reconciliation
CE_260_CF_REVERSAL_V
Bank Statement Reconciliation
CE_INTERNAL_BANK_ACCTS_GT_V
Cash Positioning
CE_XLA_EXT_HEADERS_V
Subledger Accounting
CE_INTERNAL_BANK_ACCTS_V
Bank Account Model
CE_BANKS_V
Bank Account Model
CE_BANK_ACCTS_SEARCH_GT_V
Bank Account Model
CE_XLA_TRANSACTIONS_V
Subledger Accounting
CEFV_BANK_ACCOUNTS
Business Intelligence Service
CEBV_BANK_ACCOUNTS
Business Intelligence Service
CEFV_BANK_BRANCHES
Business Intelligence Service
CEBV_BANK_BRANCHES
Business Intelligence Service
Changed Views
View
Name
Feature Area
Brief Description of Change
CE_101_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_101_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_185_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_185_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Subledger Accounting and Bank Account Model
features
CE_200_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_200_BATCHES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_200_REVERSAL_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_200_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_BATCHES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_REVERSAL_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_TXN_FOR_BATCH_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_260_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_260_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_EFT_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_EFT_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_999_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_999_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_999_REVERSAL_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_ALL_STATEMENTS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_ARCH_RECONCILIATIONS
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_AVAIL_STATEMENTS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_AVAILAVLE_BATCHES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_AVAILAVLE_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_BANK_TRX_CODES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_INTERNAL_BANK_ACCOUNTS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_MISC_TAX_CODE_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_MISC_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_RECEIVABLE_ACTIVITIES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_RECONCILED_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_REVERSAL_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_STAT_HDRS_INF_V
Bank Statement Reconciliation
Enhancement related to MOAC, Balances and Interests Calculation and Bank
Account Model feature
CE_STATEMENT_HEADERS_V
Bank Statement Reconciliation
Enhancement related to MOAC, Balances and Interests Calculation and Bank
Account Model features
CE_STATEMENT_LINES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_STATEMENT_RECONCILIATIONS
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_SYSTEM_PARAMETERS
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_SYSTEM_PARAMETERS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_TRANSACTION_CODES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CEBV_CASH_FORECAST_CELLS
BIS Views
Enhancement related to Bank Account Model features
CEBV_ECT
BIS Views
Enhancement related to Bank Account Model features
CEFV_BANK_STATEMENTS
BIS Views
Enhancement related to Bank Account Model features
CEFV_CASH_FORECAST_CELLS
BIS Views
Enhancement related to Bank Account Model features
CEFV_ECT
BIS Views
Enhancement related to Bank Account Model features
CE_TRANSACTION_CODES_V
Bank Statement Reconciliation
Enhancement related to Bank Statement Reconciliation features
CE_CP_XTR_BANK_ACCOUNTS_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_XTR_CASHFLOWS_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_AP_FC_PAYMENTS_V
Cash Forecasting
Enhancement related to Bank Account Model features
CE_AR_FC_RECEIPTS_V
Cash Forecasting
Enhancement related to Bank Account Model features
CE_AR_FC_INVOICES_V
Cash Forecasting
Invalid object fix
CE_SO_FC_ORDERS_V
Cash Forecasting
Invalid object fix
CE_SO_FC_ORDERS_NO_TERMS_V
Cash Forecasting
Invalid object fix
CE_SO_FC_ORDERS_TERMS_V
Cash Forecasting
Invalid object fix
CE_FORECAST_ROWS_V
Cash Forecasting
Invalid object fix
CE_CP_BANK_ACCOUNTS_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_WS_BA_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_DISC_OPEN_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_WS_LE_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_XTO_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_SUB_OPEN_BAL_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_WS_BA_DISC_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_P_BA_SIGNATORY_HIST_V
BIS View
Enhancement related to Bank Account Model features
CE_FC_ARI_DISC_V
Cash Forecasting
Enhancement related to Subledger Accounting features
Obsoleted Views
View
Name Feature
Area
Replaced By
CE_ARCH_HEADERS
Bank Statement
Table with the same name
CE_ARCH_INTERFACE_HEADERS
Bank Statement
Table with the same name
CE_ARCH_INTRA_HEADERS
Bank Statement
Table with the same name
CE_INTRA_STMT_HEADERS
Bank Statement
Table with the same name
CE_STATEMENT_HEADERS
Bank Statement
Table with the same name
CE_STATEMENT_HEADERS_INTERFACE
Bank Statement
Table with the same name
R12
Iprocurement
New
Tables
Table Name
Feature Area
ICX_CAT_ATTRIBUTES_TL
Catalog Authoring, Shopping
ICX_CAT_BATCH_JOBS_ALL
Catalog Authoring
ICX_CAT_CONTENT_ZONES_B
Catalog Authoring, Shopping
ICX_CAT_CONTENT_ZONES_TL
Catalog Authoring, Shopping
ICX_CAT_CONVERTER_DETAILS
Catalog Authoring
ICX_CAT_DELETED_SQES
Catalog Authoring
ICX_CAT_FAV_LIST_HEADERS
Catalog Authoring, Shopping
ICX_CAT_FAV_LIST_LINES_TLP
Catalog Authoring, Shopping
ICX_CAT_ITEMS_CTX_DTLS_TLP
Catalog Authoring, Shopping
IX_CAT_ITEMS_CTX_HDRS_TLP
Catalog Authoring, Shopping
ICX_CAT_PARSE_ERRORS
Catalog Authoring
ICX_CAT_PUNCHOUT_ZONE_DETAILS
Catalog Authoring, Shopping
ICX_CAT_R12_UPGRADE
R12 Upgrade
ICX_CAT_R12_UPGRADE_JOBS
R12 Upgrade
ICX_CAT_R12_UPG_AUTOSOURCE
R12 Upgrade
ICX_CAT_R12_UPG_EXCEP_FILES
R12 Upgrade
ICX_CAT_R12_UPG_ERROR_MSGS
R12 Upgrade
ICX_CAT_SECURE_CONTENTS
Catalog Authoring, Shopping
ICX_CAT_SHOP_STORES_B
Catalog Authoring, Shopping
ICX_CAT_SHOP_STORES_TL
Catalog Authoring, Shopping
ICX_CAT_STORE_CONTENTS
Catalog Authoring, Shopping
ICX_CAT_ZONE_ATTRIBUTES
Catalog Authoring, Shopping
ICX_CAT_ZONE_SECURE_ATTRIBUTES
Catalog Authoring, Shopping
Changed Tables N/A
Obsolete Tables
Table
Name
Feature
Area
Optional - Replaced By
ICX_CAT_CATEGORY_ITEMS
Catalog Authoring, Shopping
ICX_CAT_EXT_ITEMS_TLP
Catalog Authoring, Shopping
PO_ATTRIBUTE_VALUES,
PO_ATTRIBUTE_VALUES_TLP
ICX_CAT_ITEMS_B
Catalog Authoring, Shopping
ICX_CAT_ITEMS_TLP
Catalog Authoring, Shopping
ICX_CAT_ITEMS_CTX_HDRS_TLP
ICX_CAT_ITEM_PRICES
Catalog Authoring, Shopping
ICX_CAT_ITEM_SRC_DETAILS
Catalog Authoring, Shopping
ICX_CAT_ZONE_SECURE_ATTRIBUTES,
ICX_CAT_ZONE_ATTRIBUTES
ICX_POR_ITEM_SOURCES
Catalog Authoring, Shopping
ICX_CAT_CONTENT_ZONES_B
ICX_POR_ITEM_SOURCES_TL
Catalog Authoring, Shopping
ICX_CAT_CONTENT_ZONES_TL
ICX_CAT_PRICE_LISTS
Catalog Authoring, Shopping
ICX_CAT_STORES_B
Catalog Authoring, Shopping
ICX_CAT_SHOP_STORES_B
ICX_CAT_STORES_TL
Catalog Authoring, Shopping
ICX_CAT_SHOP_STORES_TL
ICX_CAT_STORE_CATALOGS
Catalog Authoring, Shopping
ICX_CAT_STORE_CONTENTS
ICX_CAT_STORE_ORG_ASSIGNMENTS
Catalog Authoring, Shopping
ICX_CAT_SECURE_CONTENTS
ICX_CAT_UPLOAD_IT_DUMP
Catalog Authoring
ICX_CAT_UPLOAD_PRICE_DUMP
Catalog Authoring
POR_FAVORITE_LIST_HEADERS
Catalog Authoring, Shopping
ICX_CAT_FAV_LIST_HEADERS
POR_FAVORITE_LIST_LINES
Catalog Authoring, Shopping
ICX_CAT_FAV_LIST_LINES_TLP
New Views
View
Name
Feature Area
ICX_CAT_AGREEMENT_ATTRS_V
Catalog Authoring, Shopping
ICX_CAT_CATEGORIES_V
Catalog Authoring, Shopping
ICX_CAT_CONTENT_ZONES_VL
Catalog Authoring, Shopping
ICX_CAT_LATEST_BATCH_JOBS_V
Catalog Authoring
ICX_CAT_PURCHASING_CAT_MAP_V
Catalog Authoring, Shopping
ICX_CAT_SHOPPING_CAT_MAP_V
Catalog Authoring, Shopping
ICX_CAT_SHOP_STORES_VL
Catalog Authoring, Shopping
ICX_CAT_STORE_CONTENTS_V
Catalog Authoring, Shopping
Changed Views N/A
Obsolete Views N/A
R12 FA I
AR
Fixed Assets
New Tables
Table
Name
Feature Area Brief Description
CSI_FA_HEADERS
Notification Process for newly added assets.
This table captures asset related information about Fixed assets that are
manually added using the Assets Workbench – The generated data is then used in
the Generate Notification concurrent process.
CSI_FA_TRANSACTIONS
Notification Process for newly added assets.
This table captures transactional information about Fixed assets that are
manually added using the Assets Workbench – The generated data is then used in
the Generate Notification concurrent process.
CSI_I_ASSET_INTERFACE
Open Interface for Instance to Fixed Asset Association
This table if loaded with the instance and asset link information will be
used by the “Install Base Open Interface” program to create the association
between the item instance and the fixed asset.
Changed Tables
Table
Name
Feature Area Brief Description of Change
CSI_I_ASSETS
Improved Integration with Fixed Assets/Common Asset Repository
Added NEW Columns
· FA_SYNC_FLAG – This tracks whether the Fixed Assets and Item Instances are in sync with respect to quantities and Location Mapping.
· FA_MASS_ADDITION_ID – This is the new linking column that stores the information about the record that is written in to FA_MASS_ADDITIONS table when the Asset Tracking concurrent program creates the interface data to create a fixed asset.
· CREATION_COMPLETE_FLAG – Column that determines whether the instance to asset link is complete or not.
CSI_INSTANCE_INTERFACE
Install Base Open Interface
· Added Asset Maintenance (EAM) support columns
· Added instance attributes from 16 to 30
· Added operational status code column
· Added Sync up family column for internal processing.
Obsolete Tables
Table
Name
Feature
Area
Optional - Replaced By
CSI_I_ASSET_TXN_TEMP
Improved Integration with Fixed Asset
This table was used to temporarily hold data before creating assets in FA.
Primarily used for grouping purpose. The grouping logic is now handled in the
code.
iReceivables
New Tables
Table
Name
Feature Area
AR_IREC_SELFREG_CUST_QS
Self Registration
AR_IREC_SELFREG_SITE_QS
Self Registration
ARI_REG_VERIFICATIONS_GT
Self Registration
AR_IREC_PRINT_REQUESTS
Print Request
Changed Tables
Table
Name
Feature
Area Brief
Description of Change
AR_SYSTEM_PARAMETERS_ALL
System Options Setup, the Receivables Activity type used for Convenience Charges.
Added column column IREC_SERVICE_CHARGE_REC_TRX_ID NUMBER(15)
Obsolete Tables
Table
Name
Feature Area
Optional - Replaced By
AR_CUST_SEARCH_GT
Customer Search
AR_CUST_SEARCH_GT_ALL
AR_IREC_CUSTOM_CUST_GT
Custom Customer Search
AR_IREC_CSTM_CUST_GT_ALL
AR_IREC_CUSTOM_SRCH_GT
Custom Transaction Search
AR_IREC_CSTM_SRCH_GT_ALL
AR_IREC_PAYMENT_LIST_GT
Transaction List/Payment Page
AR_IREC_PAYMENT_GT_ALL
HZ_REGISTRATIONS
Self Registration
HZ_REG_VERIFICATIONS
Self Registration
New Views
View Name Feature Area
ARI_CUSTOMER_SEARCH_V
Customer search for internal users
Changed
Views N/A
Obsolete
Views
N/A
iExpenses
New Tables
Table
Name
Feature Area Brief Description
OIE_PDM_DAILY_BREAKUPS
Enhanced Global Per Diem and Mileage
This table holds per diem data for a rate period.
OIE_PDM_DESTINATIONS
This table holds per diem destination information.
OIE_ADDON_MILEAGE_RATES
This table stores additional information for a mileage expense type.
OIE_POL_RATES_INTERFACE
Staging table for uploading CONUS and OCONUS rates.
OIE_ALLOCATION_PREFS
Expense Allocations
This table stores a person's allocation preferences.
OIE_DISTRIBUTION_SETS
This table stores distribution sets that make up an allocation preference.
OIE_SET_DISTRIBUTIONS
This table holds the distribution lines that belong to a distribution set.
OIE_AME_NOTIFY_GT
Data in OIE_AME_NOTIF_GT will be used for displaying instructions to the
approver in the approval notification. Example, You are responsible for
approving expenses that total 250.00 USD for cost center 420.
OIE_AME_APPROVER_AMT_GT
Data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver Amount
in the approval notification.
R12 Projects:
New
Tables
None
Changed Tables
Table Name Feature Area Brief Description of Change
PA_PROJECTS_ALL
Multi-Org Access Control (MOAC)
Multi-Org Access Control (MOAC)
Changes to these 3 tables:
· · Default value for ORG_ID has been removed
· · NOT NULL constraint is enforced on ORG_ID column
PA_PROJECT_TYPES_ALL
PA_IMPLEMENTATIONS_ALL
Obsolete Tables None
New Views None
Changed Views
View Name Feature Area
PA_CUSTOMER_SITES_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
PA_CUSTOMER_CONTACT_NAMES_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
PA_CUSTOMER_RECEIVER_PROJECTS_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
PA_STRUCTURES_TASKS_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
PA_TASK_CUSTOMERS_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
PA_PROJECT_CONTACTS_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
PA_PROJECT_CUSTOMERS_V
Replaced RA backward-compatible views with direct joins to underlying HZ tables.
PA_PROJECTS
MOAC
Single Org View Changes for 3 views
· · Drop the single organization view
· · Create a synonym with the same name as the single organization view in
APPS schema.
· · Attach policy function to the synonym
PA_PROJECT_TYPES
PA_IMPLEMENTATIONS
PA_TASKS_WBS_V
Replaced RA backward-compatible views with direct joins to underlying HZ
tables.
Obsolete Views None
AR R12
Tables:
New Tables Description of Change
AR_REC_TRX_LE_DETAILS_ALL
Added detail
level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a
receivables activity and the sets of asset and liability tax codes by legal
entity.
AR_DEFERRAL_REASONS
Revenue Deferral
Reasons
AR_DEFERRED_LINES_ALL
Revenue Deferral
Reasons
AR_RDR_PARAMETERS_GT
Revenue Deferral
Reasons
AR_REVIEWED_LINES_GT
Revenue Deferral
Reasons
Changed Tables
Table Name Description of Change
RA_CUSTOMER_TRX_LINES_ALL
Added numerous
columns to support E-Business Tax and line-level Ship To, Added Payment
extension identifier.
AR_MEMO_LINES
Added
tax_product_category to support E-Business Tax uptake.
AR_TRX_LINES_GT
Added numerous
columns to support E-Business Tax uptake, Added parent_line_id and
deferral_exclusion_flag.
AR_TRX_LINES_TMP_GT
Added numerous
columns to support E-Business Tax uptake, Added parent_line_id and
deferral_exclusion_flag.
AR_ARCHIVE_DETAIL
Added numerous columns
to support E-Business Tax and line-level Ship To,
RA_BATCH_SOURCES_ALL
Obsoleted
invalid_tax_rate_rule column.
HZ_CUST_SITE_USES
Migrated
tax_code, tax_header_level_flag, tax_reference, and tax_classification to
ZX_PARTY_TAX_PROFILE and ZX_REGISTRATIONS tables.
AR_CASH_RECEIPTS_ALL
Added Payment
extension identifier and obsoleted, approval_code,
address_verification_code,
payment_server_order_num, Renamed column REMITTANCE_BANK_ACCOUNT_ID to
REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
AR_RECEIPT_METHODS
Added Payment
Channel Code and obsoleted, payment_type_code, merchant_ref, merchant_id,
auto_print_program_id
RA_CUSTOMER_TRX_ALL
Added Payment
extension identifier and Payment Attributes,
obsoleted
payment_server_order_num, approval_code, address_verification_code, Renamed
column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added
legal_entity_id column.
RA_INTERFACE_LINES_ALL
Added Payment
extension identifier and Payment Attributes, and obsoleted
payment_server_order_num, approval_code, address_verification_code, Added
legal_entity_id column, Added parent_line_id and deferral_exclusion_flag.
AR_AUTOREC_EXCEPTIONS
Renamed column
REMIT_BANK_ACCT_ID to REMIT_BANK_ACCT_USE_ID
AR_BATCHES_ALL
AR_BATCHES_ALL
Renamed column
REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_BATCH_SOURCES_ALL
Renamed column
DEFAULT_REMIT_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_INTERIM_CASH_RECEIPTS_ALL
Renamed column
REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_RECEIPT_METHOD_ACCOUNTS_ALL
Renamed column
BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
AR_TRX_HEADER_GT
AR_TRX_HEADER_GT
Added
legal_entity_id column
AR_TRX_HEADER_TMP_GT
Added
legal_entity_id column
AR_LINE_CONTS_ALL
Added
contingency_id as a foreign key to AR_DEFERRAL_REASONS
AR_TRX_CONTINGENCIES_GT
Added
contingency_id, expiration_event_date and completed_flag.
Obsolete Tables
Table Name
AR_TA_ASGN_TO_INT_ALL
AR_TA_CASHAPP_OB_ALL
AR_TA_CR_AGEN_INF_ALL
AR_TA_CUST_HIER_CHILD
AR_TA_CUST_HIER_PARNT
AR_TA_CUST_INT_ALL
AR_TA_CUST_TRXSTR_ALL
AR_TA_DEDN_ASSGNS_ALL
AR_TA_DEDN_INT_ALL
AR_TA_DEDN_RELATE_ALL
AR_TA_LEGACY_CUST_INT
AR_TA_LEGACY_STAT_INT
AR_TA_PAYMNT_HIST_ALL
AR_TA_PROF_ASSGNT_ALL
AR_TA_PROMOTIONS_ALL
AR_TA_PROMOTIONS_INT
AR_TA_PROM_CUST_ALL
AR_TA_PROM_CUST_MAP
AR_TA_PROM_LINES_INT
AR_TA_PROM_PAYMNT_ALL
AR_TA_PROM_PAYMNT_TYP
AR_TA_PROM_PRODS_ALL
AR_TA_PROM_STATUS_MAP
AR_TA_RECON_INFO_ALL
AR_TA_RECV_TRXSET_ALL
AR_TA_REMIT_HIST_ALL
AR_TA_REMIT_PROF_ALL
AR_TA_RISK_COMENT_ALL
AR_TA_RULES_ALL
AR_TA_RULE_OUTPUT
AR_TA_RULE_SETS_ALL
AR_TA_RULE_SET_LN_ALL
AR_TA_TRX_SETS_ALL
AR_TA_TRX_SET_LN_ALL
AR_TA_TRX_TO_CREATE
AR_TA_TRX_TYP_INT_ALL
AR_TA_VERSIONS
New Views
View Name Description of Change
AR_MEMO_LINES_VL
Added
tax_product_category.
AR_SHIP_ADDRESS_V
Removed
hz_loc_assignments.
RA_CUSTOMER_TRX_LINES_V
Added numerous
columns
AR_DOCS_RECEIVABLES_V
AR_FUNDS_CAPTURE_ORDERS_V
ARBR_DOCS_RECEIVABLES_V
ARBR_DOCUMENT_LINES_V
ARBR_FUNDS_CAPTURE_ORDERS_V
AR_CBA_BANK_BRANCH_CONTACTS_V
AR_CBA_BANK_ACCOUNT_CONTACTS_V
AR_CBA_EFT_USER_NUMBER_V
AR_LINE_DEFERRAL_REASONS
Revenue Deferral
Reasons
AR_LINE_CONTINGENCIES_V
Revenue Deferral Reasons
AR_RDR_ITEMS_V
Reasons,
Validation Set for RDR setup
Changed Views
View Name Description of Change
AR_AUTOMATIC_RECEIPTS_FORMAT_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
AR_BOE_AUTO_RECEIPTS_V
Added Payment
extension identifier to view
AR_BOE_REMIT_RECEIPTS_CBUNR_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
AR_BOE_REMIT_RECEIPTS_NONCBR_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
AR_BOE_REMIT_RECEIPTS_V
Modified the
view to accommodate the data model changes related to payment uptake project
AR_BR_ASSIGNMENTS_V
Modified the
view to accommodate the data model changes related to payment uptake project
AR_BR_MAIN_REMIT_BATCH_V
Modified the
view to accommodate the data model changes related to payment uptake project
AR_CASH_RECEIPTS_V
Added Payment
extension identifier and payment channel identifier to view
AR_CUSTOMER_BILLS_TRX_V
Added Payment
extension identifier and payment channel identifier to view
AR_REMITTED_RECEIPTS_FORMAT_V
Added Payment
extension identifier & payment channel code to view. Also modified the view
to accommodate the data model changes related to payment uptake project.
RA_CUSTOMER_TRX_CM_V
Modified the
view to accommodate the data model changes related to payment uptake project
Added Payment
extension identifier and the payment channel identifier to view
RA_CUSTOMER_TRX_PART_CB_V
Modified the
view to accommodate the data model changes related to payment uptake project
Added Payment
extension identifier and the payment channel identifier to view
RA_CUSTOMER_TRX_PARTIAL_V
Modified the
view to accommodate the data model changes related to payment uptake project
Added Payment
extension identifier and the payment channel identifier to view
AR_AEL_GL_REC_V
Made changes to
support the new Internal Bank Account data model.
AR_AEL_SL_REC_V
Made changes to
support the new Internal Bank Account data model.
AR_CUSTOMER_BILLS_TRX_V
Made changes to
support the new Internal Bank Account data model.
AR_BR_MAIN_REMIT_BATCH_V Made changes to support the new Internal Bank Account data model.
AR_BATCHES_V Made changes to support the new Internal Bank Account data model.
AR_BATCH_REMIT_V Made changes to support the new Internal Bank Account data model.
AR_BOE_REMIT_RECEIPTS_V
Made changes to
support the new Internal Bank Account data model.
AR_CASH_RECEIPTS_V Made changes to support the new Internal Bank Account data
model.
AR_INTERIM_CR_LINES_V Made
changes to support the new Internal Bank Account
data model.
data model.
AR_CASH_RECEIPTS_V
Added legal_entity_id column
AR_CUSTOMER_BILLS_TRX_V Added legal_entity_id column
AR_PAYMENT_SCHEDULES_PMT_V Added legal_entity_id column
AR_PAYMENT_SCHEDULES_TRX2_V Added legal_entity_id column
RA_CUSTOMER_TRX_CR_TRX_V Added legal_entity_id column
RA_CUSTOMER_TRX_PARTIAL_V Added legal_entity_id column
RA_CUSTOMER_TRX_PART_CB_V Added legal_entity_id column
AR_PAYMENT_SCHEDULES_V
Added legal_entity_id column
RA_CUST_TRX_LINE_GL_DIST_V Added column user_generated_flag
RA_CUST_TRX_LINE_GL_DIST_V Added column user_generated_flag
