Tuesday 23 August 2011

R12 – Table/View Changes, Additions



 1.  General Ledger

1.1 New Tables

Table Name
Feature Area
FUN_SEQ_ASSIGNMENTS
Setup Forms and Programs
FUN_SEQ_CONTEXTS
Setup Forms and Programs
FUN_SEQ_ENTITIES
Setup Forms and Programs
FUN_SEQ_HEADERS
Setup Forms and Programs
FUN_SEQ_REQUESTS
Setup Forms and Programs
FUN_SEQ_RULES
Setup Forms and Programs
FUN_SEQ_VERSIONS
Setup Forms and Programs
GL_ACCESS_SET_ASSIGNMENTS
Setup Forms and Programs
GL_ACCESS_SET_NORM_ASSIGN
Setup Forms and Programs
GL_ACCESS_SETS
Setup Forms and Programs
GL_AUTOREV_CRITERIA_SETS
Journal Entry
GL_BC_PACKETS_HISTS
Budgets and related objects
GL_BUDORG_BC_OPTIONS
Budgets and related objects
GL_COA_MAPPINGS
Consolidation and Eliminations
GL_DEFAS_ACCESS_SETS
Setup Forms and Programs
GL_DEFAS_ASSIGNMENTS
Setup Forms and Programs
GL_DEFAS_RESP_ASSIGN
Setup Forms and Programs
GL_JE_INCLUSION_RULES
Setup Forms and Programs
GL_JE_LINES_RECON
Reconciliation
GL_JE_SEGMENT_VALUES
Journal Entry
GL_LE_VALUE_SETS
Setup Forms and Programs
GL_LEDGER_CONFIG_DETAILS
Setup Forms and Programs
GL_LEDGER_CONFIGURATIONS
Setup Forms and Programs
GL_LEDGER_NORM_SEG_VALS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
Setup Forms and Programs
GL_LEDGER_SEGMENT_VALUES
Setup Forms and Programs
GL_LEDGER_SET_ASSIGNMENTS
Setup Forms and Programs
GL_LEDGER_SET_NORM_ASSIGN
Setup Forms and Programs
GL_LEDGER_SET_REQUESTS
Setup Forms and Programs
GL_LEDGERS
Setup Forms and Programs
GL_LEGAL_ENTITIES_BSVS
Setup Forms and Programs
GL_MGT_SEG_UPGRADE
Other Issues
GL_MGT_SEG_UPGRADE_H
Other Issues
GL_SEG_VAL_HIERARCHIES
Setup Forms and Programs
GL_SEG_VAL_NORM_HIERARCHY
Setup Forms and Programs
GL_SUMMARY_BC_OPTIONS
Budgets and related objects

 

1.2 Changed Tables

The set_of_books_id column has been renamed to ledger_id in all tables with some exceptions as mentioned below.  All setups secured by definition access sets have a new security_flag column in the relevant tables. 
Table Name
Feature Area
Brief Description of Change
GL_ALLOC_FORMULAS
MassAllocations, Budgets and Encumbrances
Add currency_conversion_type to support foreign currency allocations
GL_AUTO_ALLOC_SETS
MassAllocations, Budgets and Encumbrances
Add chart_of_accounts_id, period_set_name and accounting_period_type to enable sharing of AutoAllocations across ledgers sharing the same chart of accounts and calendar
GL_AUTOMATIC_POSTING_OPTIONS
Posting
Add ledger_id to enable AutoPost across ledgers
GL_AUTOMATIC_POSTING_SETS 
Posting
Add chart_of_accounts_id, period_set_name and accounting_period_type to enable sharing of AutoPost Criteria Sets across ledgers sharing the same chart of accounts and calendar
GL_AUTOREVERSE_OPTIONS
Journal Entry
Add criteria_set_id to support AutoReverse criteria sets stored in the master table GL_AUTOREV_CRITERIA_SETS
GL_BALANCES
Balances and Related Objects
Add quarter_to_date_dr_beq, quarter_to_date_cr_beq, project_to_date_dr_beq and project_to_date_cr_beq to store entered ledger currency balances
GL_CODE_COMBINATIONS
Setup Forms and Programs
Add alternate_code_combination_id to support replacement for disabled accounts functionality implemented by Journal Import
GL_CONSOLIDATION
Consolidation and Eliminations
Add coa_mapping_id to enable consolidations to use chart of accounts mappings
GL_INTERFACE
Journal Import
Add ledger_id and retain set_of_books_id for backward compatibility
GL_JE_BATCHES
Journal Entry
Drop set_of_books_id and add chart_of_accounts_id, period_set_name and accounting_period_type to support batches containing journals for multiple ledgers sharing the same chart of accounts and calendar
GL_JE_HEADERS
Journal Entry
Add columns to store the accounting and reporting sequences
GL_PERIOD_STATUSES
Setup Forms and Programs
Add ledger_id and retain set_of_books_id for backward compatibility
GL_RECURRING_HEADERS
Recurring Journals and Budgets
Add currency_conversion_type to support foreign currency recurring journals
GL_SYSTEM_USAGES
Setup Forms and Programs
Add efb_upgrade_flag and reconciliation_upg_flag to track successfully completed optional post-update programs

 

2.3 Obsolete Tables

 

None of the obsolete tables have been dropped.  Some obsolete tables have been renamed with the suffix _11i.  Some obsolete tables are highlighted below.
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

 

2.4 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

2.5 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



2.6 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

  


2.  iExpenses



2.1 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.




2.2 Changed Tables

 

Table Name                                 
Feature Area                                          
Brief Description of Change                                                                  
AP_POL_HEADERS
Enhanced Global Per Diem and Mileage
New Columns:
  • SCHEDULE_TYPE_CODE
  • MIN_TRIP_DURATION
  • SAME_DAY_RATE_CODE
  • NIGHT_RATES_CODE
  • NIGHT_RATE_ELIGIBILITY
  • NIGHT_RATE_START_TIME
  • NIGHT_RATE_END_TIME
  • MULTI_DEST_RULE_CODE
  • MULTI_DEST_START_TIME
  • MULTI_DEST_END_TIME
  • RATE_PERIOD_TYPE_CODE
  • SOURCE
  • PER_DIEM_TYPE_CODE
  • MEALS_TYPE_CODE
  • ALLOWANCE_TIME_RULE_CODE
  • BREAKFAST_START_TIME
  • BREAKFAST_END_TIME
  • LUNCH_START_TIME
  • LUNCH_END_TIME
  • DINNER_START_TIME
  • DINNER_END_TIME
  • USE_MAX_DEST_RATE_FLAG
AP_POL_SCHEDULE_OPTIONS
Enhanced Global Per Diem and Mileage
New Columns:
  • RATE_TYPE_CODE
AP_POL_SCHEDULE_PERIODS
Enhanced Global Per Diem and Mileage
New Columns:
  • MIN_RATE_PER_PERIOD
  • MAX_BREAKFAST_DEDUCTION_AMT
  • MAX_LUNCH_DEDUCTION_AMT
  • MAX_DINNER_DEDUCTION_AMT
  • FIRST_DAY_RATE
  • LAST_DAY_RATE
AP_POL_LINES
Enhanced Global Per Diem and Mileage
New Columns:
  • ADDON_MILEAGE_RATE_CODE
  • RATE_PER_PASSENGER
  • RATE_TYPE_CODE
  • ONE_MEAL_DEDUCTION_AMT
  • TWO_MEALS_DEDUCTION_AMT
  • THREE_MEALS_DEDUCTION_AMT
  • NIGHT_RATE_TYPE_CODE
  • ACCOMMODATION_CALC_METHOD
  • START_OF_SEASON
  • END_OF_SEASON
  • MAX_LODGING_AMT
  • NO_GOVT_MEALS_AMT
  • PROP_MEALS_AMT
  • OFF_BASE_INC_AMT
  • FOOTNOTE_AMT
  • FOOTNOTE_RATE_AMT
  • MAX_PER_DIEM_AMT
  • EFFECTIVE_START_DATE
  • EFFECTIVE_END_DATE
AP_POL_LINES_HISTORY
Enhanced Global Per Diem and Mileage
New Columns:
  • ADDON_MILEAGE_RATE_CODE
  • RATE_PER_PASSENGER
  • RATE_TYPE_CODE
  • ONE_MEAL_DEDUCTION_AMT
  • TWO_MEALS_DEDUCTION_AMT
  • THREE_MEALS_DEDUCTION_AMT
  • NIGHT_RATE_TYPE_CODE
  • ACCOMMODATION_CALC_METHOD
  • START_OF_SEASON
  • END_OF_SEASON
  • MAX_LODGING_AMT
  • NO_GOVT_MEALS_AMT
  • PROP_MEALS_AMT
  • OFF_BASE_INC_AMT
  • FOOTNOTE_AMT
  • FOOTNOTE_RATE_AMT
  • MAX_PER_DIEM_AMT
  • EFFECTIVE_START_DATE
  • EFFECTIVE_END_DATE
AP_EXPENSE_REPORT_LINES_ALL
Enhanced Global Per Diem and Mileage
New Columns:
  • RATE_PER_PASSENGER
  • PASSENGER_RATE_TYPE
  • PASSENGER_AMOUNT
  • RANGE_LOW
  • RANGE_HIGH
  • UOM_DAYS
AP_POL_LOCATIONS_B
Enhanced Global Per Diem and Mileage
New Columns:
  • LOCATION_TYPE
  • COUNTRY
  • STATE_PROVINCE_ID
  • COUNTY_ID
  • CITY_LOCALITY_ID
AP_CARDS_ALL
Credit Card Data Model Consolidation Uptake
New Column:
  • CARD_REFERENCE_ID - References IBY_CREDITCARD.INSTRID

Modified Column:
  • CARD_NUMBER - Is a nullable column since valid card numbers are no longer stored in this table.
AP_CREDIT_CARD_TRXNS_ALL
New Column:
  • CARD_ID - References AP_CARDS_ALL.CARD_ID

Modified Column:
  • CARD_NUMBER - Is a nullable column since valid card numbers are no longer stored in this table.
AP_EXPENSE_REPORT_LINES_ALL
Itemization
New Columns:
  • ALLOCATION_SPLIT_CODE
  • ALLOATION_REASON
Modified columns:
  • ITEMIZATION_PARENT_ID - Represents a line's involvement in an itemization: NULL indicates the line is not involved in an itemization and -1 indicates the line is a parent receipt line for an itemization. Any value > 0 indicates the line is an itemized child line where ITEMIZATION_PARENT_ID is the REPORT_LINE_ID of the child's parent line.
  • ITEMIZE_ID - No longer used.
  • CODE_COMBINATION_ID - Is now nullable and no longer used.
  • FLEX_CONCATENATED - No longer used.
  • PROJECT_ID - No longer used.
  • PROJECT_NUMBER - No longer used.
  • PROJECT_NAME - No longer used.
  • TASK_ID - No longer used.
  • TASK_NUMBER - No longer used.
  • TASK_NAME - No longer used.
  • AWARD_ID - No longer used.
  • AWARD_NUMBER - No longer used.
  • EXPENDITURE_ORGANIZATION_ID - No longer used.
AP_EXP_REPORT_DISTS_ALL
Expense Allocations
New Columns:
  • AMOUNT
  • PROJECT_ID
  • TASK_ID
  • AWARD_ID
  • EXPENDITURE_ORGANIZATION_ID
  • COST_CENTER
AP_WEB_ACCFLEX_SEGMENTS
Expense Allocations
New Column:
  •  SET_OF_BOOKS_ID
AP_EXPENSE_REPORT_HEADERS_ALL
Cash Advances Management
New Column:
  • ADVANCES_JUSTIFICATION
AP_AUD_RUL_SETS
Cash Advances Management
New Column:
  • AUDIT_ALL_UNUSED_ADVANCES
AP_EXPENSE_REPORT_HEADERS_ALL
Expense Report Export
New Column:
  • REQUEST_ID - Used for identifying the Expense Report Export concurrent program request id that processed the expense report

2.3 Obsolete Tables

 

Table Name                                 
Feature Area                                          
Optional - Replaced By                                                                  



 

2.4 New Views

 

View Name                                 
Feature Area                                          


2.5 Changed Views

 

View Name
Feature Area
Brief Description of Change
AP_POL_LOCATIONS_VL
Enhanced Global Per Diem and Mileage
Add columns used for location type information.
AP_POL_LOCATIONS_V
Add columns used for location type information.

2.6 Obsoleted Views

 

View Name                                 
Feature Area                                          
Optional - Replaced By                                                                  










3.  Cash Management (CE)




3.1 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

3.2 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

3.3 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

 

3.4 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

3.5 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

3.6 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


4.  iReceivables


4.1 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

4.2 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)







4.3 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

 

4.4 New Views

View Name                                 
Feature Area                                          
ARI_CUSTOMER_SEARCH_V
Customer search for internal users




4.5 Changed Views

View Name                                 
Feature Area                                          
Brief Description of Change                                                                  



4.6 Obsolete Views

View Name                                 
Feature Area                                          
Optional - Replaced By                                                                  






5.  Fixed Assets




5.1 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.

5.2 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.




5.3 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.






 

5.4 New Views

View Name                                 
Feature Area                                          


5.5 Changed Views

View Name                                 
Feature Area                                          
Brief Description of Change                                                                  



5.6 Obsolete Views

View Name                                 
Feature Area                                          
Optional - Replaced By                                                                  






6.  Projects




6.1 New Tables

None

6.2 Changed Tables

Table Name                                 
Feature Area                                          
Brief Description of Change                                                                  
 PA_PROJECTS_ALL
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

6.3 Obsolete Tables

None

6.4 New Views


None

 

6.5 Changed Views

View Name                                 
Feature Area                                          
Brief Description of Change                                                                  
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.

6.6 Obsolete Views

None 


7.  Tax


7.1 New Tables

Oracle E-Business Tax is a new product in Release 12.

 7.2 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.




7.3 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

 

7.4 New Views

Oracle E-Business Tax is a new product in Release 12.

7.5 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.



7.6 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

 

8.  iProcurement


8.1 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 
ICX_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 

8.2 Changed Tables

Table Name                                 
Feature Area                                          
Brief Description of Change                                                                  
 None.


8.3 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

8.4 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

8.5 Changed Views

View Name                                 
Feature Area                                          
Brief Description of Change                                                                  
 None.


8.6 Obsolete Views

View Name                                 
Feature Area                                          
Optional - Replaced By                                                                  
 None.




9. Purchasing



9.1 New Tables

Table Name                                 
Feature Area                                          
Professional Buyer’s Work Center
PO_DRAFTS
Draft Architecture (see “Technical Architecture Considerations” below)
PO_HEADERS_DRAFT_ALL
Draft Architecture
PO_LINES_DRAFT_ALL
Draft Architecture
PO_LINE_LOCATIONS_DRAFT_ALL
Draft Architecture
PO_DISTRIBUTIONS_DRAFT_ALL
Draft Architecture
PO_GA_ORG_ASSIGN_DRAFT
Draft Architecture
PO_PRICE_DIFF_DRAFT
Draft Architecture
PO_NOTIFICATION_CTRL_DRAFT
Draft Architecture
PO_ATTRIBUTE_VALUES_DRAFT
Draft Architecture
PO_ATTRIBUTE_VALUES_TLP_DRAFT
Draft Architecture
Enhanced Catalog Access
PO_ATTRIBUTE_VALUES
Item attributes in Unified Catalog
PO_ATTRIBUTE_VALUES_TLP
Item attributes in Unified Catalog
PO_ATTR_VALUES_INTERFACE
Item attributes in Unified Catalog
PO_ATTR_VALUES_TLP_INTERFACE
Item attributes in Unified Catalog
PO_ATTR_VALUES_ARCHIVE
Item attributes in Unified Catalog
PO_ATTR_VALUES_TLP_ARCHIVE
Item attributes in Unified Catalog
Document Styles
 PO_DOC_STYLE_HEADERS
Document Styles
 PO_DOC_STYLE_VALUES
Document Styles
 PO_DOC_STYLE_LINES_B
Document Styles
 PO_DOC_STYLE_LINES_TL
Document Styles
New User Interface for Oracle Purchasing Setups
PO_CHANGE_ORDER_TOLERANCES_ALL
Tolerances 

Uptake Subledger Accounting for Funds Control
PO_BC_DISTRIBUTIONS
 Uptake Subledger Accounting for Funds Control
Purchase Document Open Interface Enhancements
PO_LINE_LOCATIONS_INTERFACE
Interface table for price breaks and standard PO shipments 
 PO_ATTR_VALUES_INTERFACE
Interface table for line non-translatable attribute values 
 PO_ATTR_VALUES_TLP_INTERFACE
 Interface table for line translatable attribute values 

9.2 Changed Tables

Table Name                                 
Feature Area                                          
Brief Description of Change                                                                  
Professional Buyer’s Work Center
 PO_HEADERS_ALL
PO Communication Details
Added columns (SUPPLIER_NOTIF_METHOD, FAX, EMAIL_ADDRESS) for capturing the Communication Details specified for a PO on the Create/Update Order page.
 PO_HEADERS_ARCHIVE_ALL
PO Communication Details
As above.
Enhanced Catalog Access
 PO_HEADERS_ALL
Unified Catalog
Added new columns:
created_language
cpa_reference
last_updated_program
 PO_HEADERS_ARCHIVE_ALL
Unified Catalog
Added new columns:
created_language
cpa_reference
last_updated_program
 PO_HEADERS_INTERFACE
Unified Catalog
Added new columns:
created_language
cpa_reference
last_updated_program
PO_LINES_ALL
Unified Catalog
Added new columns:
catalog_name
supplier_part_auxid
ip_category_id
last_updated_program
PO_LINES_ARCHIVE_ALL
Unified Catalog
Added new columns:
catalog_name
supplier_part_auxid
ip_category_id
last_updated_program
PO_LINES_INTERFACE
Unified Catalog
Added new columns:
catalog_name
supplier_part_auxid
ip_category_id
processing_id
PO_REQEXPRESS_LINES_ALL
Unified Catalog
Added new columns:
ip_category_id
last_updated_program
PO_INTERFACE_ERRORS
Unified Catalog
Added new column:
column_value
Document Styles
 PO_HEADERS_ALL
Document Styles
Added the STYLE_ID column for capturing the style of each document.
 PO_HEADERS_ARCHIVE_ALL
Document Styles
As above.
 PO_HEADERS_INTERACE
Document Styles
As above.
Procurement for Complex Services 
PO_LINES_ALL
 Complex Work Procurement
Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

PO_LINES_DRAFT_ALL
 Complex Work Procurement
 Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

 PO_LINES_INTERFACE
  Complex Work Procurement
 Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)
  • ADVANCE_AMOUNT(The amount of upfront financing provided as an Advance against this Contract line.)

PO_LINES_ARCHIVE_ALL
Complex Work Procurement
 Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

PO_LINE_LOCATIONS_ALL
Complex Work Procurement
Addition of the following Columns :
  • VALUE_BASIS(
  • MATCHING_BASIS
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
  • AMOUNT_SHIPPED
PO_LINE_LOCATIONS_DRAFT_ALL
Complex Work Procurement
Addition of the following Columns :
  • VALUE_BASIS(
  • MATCHING_BASIS
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
  • AMOUNT_SHIPPED
PO_LINE_LOCATIONS_ARCHIVE_ALL
Complex Work Procurement
Addition of the following Columns :
  • VALUE_BASIS(
  • MATCHING_BASIS
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
  • AMOUNT_SHIPPED
PO_LINE_LOCATIONS_INTERFACE
Complex Work Procurement
Addition of the following Columns :
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_NAME
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • AUCTION_PAYMENT_ID   
PO_DISTRIBUTIONS_ALL
Complex Work Procurement
Addition of the following Columns :
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
PO_DISTRIBUTIONS_DRAFT_ALL
Complex Work Procurement
Addition of the following Columns :
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
PO_DISTRIBUTIONS_ARCHIVE_ALL
Complex Work Procurement
Addition of the following Columns :
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
E-Business Tax
PO_HEADERS_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_LINES_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_LINE_LOCATIONS_ALL
E-Business Tax Integration
Added columns tax_attribute_update_code and original_shipment_id
 PO_DISTRIBUTIONS_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_REQUISITION_HEADERS_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_REQISITION_LINES_ALL
E-Business Tax Integration
Added columns tax_attribute_update_code and tax_name
 PO_RELEASES_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_REQUISITIONS_INTERFACE_ALL
E-Business Tax Integration
Added column tax_name
Communicate Document Attachments to Suppliers
PO_SYSTEM_PARAMETERS_ALL
Zipped file attachments
Added columns (MAX_ATTACHMENT_SIZE and EMAIL_ATTACHMENT_FILENAME) for capturing the details regarding the zip file generated for the file attachments.  These correspond to the values stored during Setup
New User Interface for Oracle Purchasing Setups
PO_SYSTEM_PARAMETERS_ALL
Zipped file attachments in Purchasing Options Page
Added columns (MAX_ATTACHMENT_SIZE and EMAIL_ATTACHMENT_FILENAME) for capturing the details regarding the zip file generated for the file attachments

Uptake Subledger Accounting for Funds Control
PO_ENCUMBRANCE_GT
 SLA: Uptake Subledger Accounting for Funds Control
Added new columns like value_basis, payment_type to accommodate Complex Work uptake and  entered_amount, gl_period_date to accommodate new requirements for SLA.
 PO_ONLINE_REPORT_TEXT
SLA: Uptake Subledger Accounting for Funds Control
 Added the columns show_in_psa_flag, segment1, distribution_type to add support for reporting PO errors through the new SLA OA page(PSA: Budgetary Control Results Page).
Purchase Document Open Interface Enhancements
PO_HEADERS_INTERFACE
PDOI Processing
Add columns to support catalog upload as well as PDOI bulk processing
 PO_LINES_INTERFACE
PDOI Processing
Add columns to support catalog upload as well as PDOI bulk processing
 PO_DISTRIBUTIONS_INTERFACE
PDOI Processing
Add columns to support PDOI bulk processing
PO_PRICE_DIFF_INTERFACE
PDOI Processing
Add columns to support PDOI bulk processing
Charge Based Shikyu - Impacts to Purchasing
 PO_LINE_LOCATIONS_ALL
shikyu
Added a not null column OUTSOURCED_ASSEMBLY for capturing whether the item is a shikyu or not..
 PO_LINE_LOCATIONS_ARCHIVE_ALL
shikyu
As above.
PO_LINE_LOCATIONS_DRAFT_ALL
shikyu
As above.
Requisition Fulfillment - DBI
PO_HEADERS_ALL

Added column SUBMIT_DATE to record the date when purchase order is submitted for approval.
PO_HEADERS_ARCHIVE_ALL

Added column SUBMIT_DATE to record the date when purchase order is submitted for approval.
PO_REQUISITION_HEADERS_ALL

Added column APPROVED_DATE to record the approval date of the requisition.
PO_RELEASES_ALL

Added column SUBMIT_DATE to record the date when release is submitted for approval.
PO_LINE_LOCATIONS_ALL

Added columns SHIPMENT_CLOSED_DATE, CLOSED_FOR_INVOICE_DATE, and CLOSED_FOR_RECEIVING_DATE to record the various dates in lifetime of a requisition line.
PO_LINE_LOCATIONS_ARCHIVE_ALL

Added columns SHIPMENT_CLOSED_DATE, CLOSED_FOR_INVOICE_DATE, and CLOSED_FOR_RECEIVING_DATE to record the various dates in lifetime of a requisition line.

9.3 Obsoleted Tables

Table Name                                 
Feature Area                                          
Optional - Replaced By                                                                  
none








 9.4 New Views

View Name                                 
Feature Area                                          
Professional Buyer’s Work Center
PO_HEADERS_MERGE_V
Draft Architecture
PO_LINES_MERGE_V
Draft Architecture
PO_LINE_LOCATIONS_MERGE_V
Draft Architecture
PO_DISTRIBUTIONS_MERGE_V
Draft Architecture
PO_GA_ORG_ASSIGN_MERGE_V
Draft Architecture
PO_PRICE_DIFF_MERGE_V
Draft Architecture
PO_NOTIFICATION_CTRL_MERGE_V
Draft Architecture
PO_ATTR_VALUES_MERGE_V
Draft Architecture
PO_ATTR_VALUES_TLP_MERGE_V
Draft Architecture
Document Styles
 PO_DOC_STYLE_LINES_VL
Document Styles
 PO_ALL_DOC_STYLE_LINES
Document Styles
PO_STYLE_ENABLED_LINE_TYPES
Document Styles
PO_STYLE_ENABLED_PAY_ITEMS
Document Styles
PO_STYLE_ENABLED_PUR_BASES
Document Styles

Uptake Subledger Accounting for Funds Control
 PO_EXTRACT_DETAIL_V
Uptake Subledger Accounting for Funds Control
PO_DISTS_REF_V
Uptake Subledger Accounting for Funds Control
PO_EXTRACT_HEADER_V
Uptake Subledger Accounting for Funds Control
PO_HEADERS_REF_V
Uptake Subledger Accounting for Funds Control
PO_LINES_REF_V
Uptake Subledger Accounting for Funds Control
PO_LINE_LOCATIONS_REF_V
Uptake Subledger Accounting for Funds Control
PO_RELEASE_TRANSACTION_V
Uptake Subledger Accounting for Funds Control
PO_REQ_DISTS_REF_V
Uptake Subledger Accounting for Funds Control
PO_REQ_EXTRACT_DETAIL_V
Uptake Subledger Accounting for Funds Control
PO_REQ_HEADERS_REF_V
Uptake Subledger Accounting for Funds Control
PO_REQ_LINES_REF_V
Uptake Subledger Accounting for Funds Control
PO_REQ_TRANSACTION_V
Uptake Subledger Accounting for Funds Control
PO_TRANSACTION_V
Uptake Subledger Accounting for Funds Control
PO_REQ_EXTRACT_HEADER_V
Uptake Subledger Accounting for Funds Control
PO_RELEASES_REF_V
Uptake Subledger Accounting for Funds Control
 PO_EXTRACT_DETAIL_V
Uptake Subledger Accounting for Funds Control

9.5 Changed Views

View Name                                 
Feature Area                                          
Brief Description of Change                                                                  

Multi-Org Access Control
 PO_REQUISITION_LINES_MRC_V

  • Added ORG_ID
  • Removed the references to client_info
  • Only driving table would have secured synonym so that the security policy function is invoked just once, rest of the tables should be base tables (_ALL tables).
  • Join for ORG_ID across _ALL tables if the table UK/PK includes ORG_ID. Example for this would be PO_DOCUMENT_TYPES that needs ORG_ID join when joining to other tables with Document Type / Subtype.
  • Removed NVL for ORG_ID joins
 PO_EMPLOYEE_HIERARCHIES

 Same as above
 PO_ALERT_BLANKET_VIEW

  Same as above
PO_ALERT_CONTRACT_VIEW

 Same as above
PO_ALERT_CONTRACT_VIEW2

 Same as above
PO_ALERT_PLANNED_VIEW

 Same as above
PO_ALERT_SCHEDULED_VIEW

 Same as above
PO_AP_RECEIPT_MATCH_V

 Same as above
PO_AP_RETROACTIVE_DIST_V

 Same as above
PO_APPROVED_SUPPLIER_LIST_V

 Same as above
PO_ASL_SUPPLIERS_V

 Same as above
PO_AUTOSOURCE_DOCUMENTS_V

 Same as above
PO_AUTOSOURCE_RULES_V

 Same as above
PO_BY_BUYER_V

 Same as above
PO_CATALOG_QUOTES_ALL_V

 Same as above
PO_CONTRACTS_VAL_V

 Same as above
PO_DISTRIBUTIONS_AP_V

 Same as above
PO_DISTRIBUTIONS_AP2_V

 Same as above
PO_DISTRIBUTIONS_INQ_V

 Same as above
PO_DISTRIBUTIONS_MRC_V

 Same as above
PO_DISTRIBUTIONS_PRINT

 Same as above
PO_DISTRIBUTIONS_V

 Same as above
PO_DOCUMENT_HEADERS_VIEW

 Same as above
PO_DOCUMENT_TYPES_ALL_VL

 Same as above
PO_DOCUMENT_TYPES_V

 Same as above
PO_DOCUMENT_TYPES_VL

 Same as above
PO_EMPLOYEE_HIERARCHIES_ALL_V

 Same as above
PO_ENC_AEL_GL_V

 Same as above
PO_HEADER_RELEASE_V

 Same as above
PO_HEADERS_AP_V

 Same as above
PO_HEADERS_CHANGE_PRINT

 Same as above
PO_HEADERS_INQ_PO_V

 Same as above
PO_HEADERS_INQ_REL_V

 Same as above
PO_HEADERS_INQ_V

 Same as above
PO_HEADERS_MRC_V

 Same as above
PO_HEADERS_PRINT

 Same as above
PO_HEADERS_RFQQT_V

 Same as above
PO_HEADERS_V

 Same as above
PO_HEADERS_VIEW

 Same as above
PO_IMPORT_SOURCES_V

 Same as above
PO_ITEM_HISTORY_V

 Same as above
PO_ITEM_SOURCES

 Same as above
PO_LINE_LOCATIONS_AP_V

 Same as above
PO_LINE_LOCATIONS_CHANGE_PRINT

 Same as above
PO_LINE_LOCATIONS_INQ_V

 Same as above
PO_LINE_LOCATIONS_PRINT

 Same as above
PO_LINE_LOCATIONS_RELEASE_V

 Same as above
PO_LINE_LOCATIONS_RFQQT_V

 Same as above
PO_LINE_LOCATIONS_V

 Same as above
PO_LINES_ALL_V

 Same as above
PO_LINES_AP_V

 Same as above
PO_LINES_ARCHIVE_XML

 Same as above
PO_LINES_CHANGE_PRINT

 Same as above
PO_LINES_INQ_V

 Same as above
PO_LINES_PRINT

 Same as above
PO_LINES_RELEASE_ITEMS_V

 Same as above
PO_LINES_RFQQT_V

 Same as above
PO_LINES_SUPPLIER_ITEMS_ALL_V

 Same as above
PO_LINES_SUPPLIER_ITEMS_V

 Same as above
PO_LINES_V

 Same as above
PO_LINES_VAL_V

 Same as above
PO_LINES_XML

 Same as above
PO_MASSCANCEL_INTERIM_V

 Same as above
PO_NEGOTIATED_SOURCES_V

 Same as above
PO_NOTIFICATION_DETAILS_V

 Same as above
PO_OWNED_LINES

 Same as above
PO_OWNED_REQUISITION_LINES

 Same as above
PO_OWNED_SHIPMENTS

 Same as above
PO_POS_ALL_V

 Same as above
PO_POS_VAL_V

 Same as above
PO_PURCHASE_HISTORY_V

 Same as above
PO_PURCHASE_ORDER_V

 Same as above
PO_QUOTATION_APPROVALS_V

 Same as above
PO_QUOTATIONS_TO_APPROVE

 Same as above
PO_REL_LINE_V

 Same as above
PO_REL_TAX_LINES_SUMMARY_V

 Same as above
PO_RELEASES_V

 Same as above
PO_RELEASES_VAL_V

 Same as above
PO_REQ_DISTRIBUTIONS_V

 Same as above
PO_REQ_TAX_LINES_SUMMARY_V

 Same as above
PO_REQEXPRESS_LINES_V

 Same as above
PO_REQS_IN_POOL_V

 Same as above
PO_REQS_IN_TRANSIT_ALL_V

 Same as above
PO_REQUISITION_HEADERS_ALL_V

 Same as above
PO_REQUISITION_HEADERS_INQ_V

 Same as above
PO_REQUISITION_HEADERS_V

 Same as above
PO_REQUISITION_LINES_INQ_V

 Same as above
PO_REQUISITION_LINES_V

 Same as above
PO_REQUISITION_TEMPLATES_V

 Same as above
PO_RFQ_HEADERS_PRINT

 Same as above
PO_RFQ_LINE_LOCATIONS_PRINT

 Same as above
PO_RFQ_LINES_PRINT

 Same as above
PO_RFQ_VENDORS_V

 Same as above
PO_RFQQT_DOCUMENT_TYPES_ALL_V

 Same as above
PO_RFQS_ALL_V

 Same as above
PO_RFQS_FOR_QUOTE_ALL_V

 Same as above
PO_RFQS_VAL_V

 Same as above
PO_RULE_EXPENSE_ACCOUNTS_V

 Same as above
PO_SHIPMENTS_ALL_V

 Same as above
PO_SHIPMENTS_AP_V

 Same as above
PO_SHIPMENTS_VAL_V

 Same as above
PO_SOURCE_SHIPMENT_NUM_V

 Same as above
PO_SOURCE_VENDORS_V

 Same as above
PO_SUPPLIER_OPEN_POS_V

 Same as above
PO_SUPPLIER_PO_SITES_VAL_V

 Same as above
PO_SUPPLIER_SITES_VAL_V

 Same as above
PO_TAX_CODES_SUMMARY_V

 Same as above
PO_TAX_DISTRIBUTIONS_DETAIL_V

 Same as above
PO_TAX_HEADERS_DETAIL_V

 Same as above
PO_TAX_LINES_DETAIL_V

 Same as above
PO_TAX_LINES_SUMMARY_V

 Same as above
PO_TAX_SHIPMENTS_DETAIL_V

 Same as above
PO_VENDOR_LIST_ENTRIES_V

 Same as above
PO_VENDOR_SITES_ALL_V

 Same as above
PO_VENDOR_SITES_AP_V

 Same as above
PO_VENDOR_SITES_PAY_AP_V

 Same as above
PO_WF_NOTIFICATIONS_V

 Same as above
POFV_REQUISITIONS

 Same as above
Support for Contractor Purchasing Users
 HR_EMPLOYEES
 Contingent Worker Uptake
Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y
 HR_EMPLOYEES_CURRENT_V
 Contingent Worker Uptake
 Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y
 PO_BUYERS_VAL_V
 Contingent Worker Uptake
 Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y
PO_BUYERS_ALL_V
Contingent Worker Uptake
 Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y

 

9.6 Obsoleted Views

View Name                                 
Feature Area                                          
Optional - Replaced By                                                                  

 Multi-Org Access Control
 PO_ACCRUAL_ACCOUNTS_TEMP

 PO_ACCRUAL_ACCOUNTS_TEMP Secured Synonym
 PO_ACCRUAL_RECONCILE_TEMP

 PO_ACCRUAL_RECONCILE_TEMP Secured Synonym
 PO_ACCRUAL_WRITE_OFFS

 PO_ACCRUAL_WRITE_OFFS Secured Synonym
PO_AUTOSOURCE_DOCUMENTS

PO_AUTOSOURCE_DOCUMENTS Secured Synonym
PO_CONTROL_GROUPS

PO_CONTROL_GROUPS Secured Synonym
PO_DISTRIBUTIONS

PO_DISTRIBUTIONS Secured Synonym
PO_DISTRIBUTIONS_ARCHIVE

PO_DISTRIBUTIONS_ARCHIVE Secured Synonym
PO_DOCUMENT_TYPES_B

PO_DOCUMENT_TYPES_B Secured Synonym
PO_DOCUMENT_TYPES_TL

PO_DOCUMENT_TYPES_TL Secured Synonym
PO_HEADERS

PO_HEADERS Secured Synonym
PO_HEADERS_ARCHIVE

PO_HEADERS_ARCHIVE Secured Synonym
PO_HISTORY_POS

PO_HISTORY_POS Secured Synonym
PO_HISTORY_REQUISITIONS

PO_HISTORY_REQUISITIONS Secured Synonym
PO_LINES

PO_LINES Secured Synonym
PO_LINES_ARCHIVE

PO_LINES_ARCHIVE Secured Synonym
PO_LINE_LOCATIONS

PO_LINE_LOCATIONS Secured Synonym
PO_LINE_LOCATIONS_ARCHIVE

PO_LINE_LOCATIONS_ARCHIVE Secured Synonym
PO_LOCATION_ASSOCIATIONS

PO_LOCATION_ASSOCIATIONS Secured Synonym
PO_MASSCANCEL_INCLUDES

PO_MASSCANCEL_INCLUDES Secured Synonym
PO_NOTIFICATIONS

PO_NOTIFICATIONS Secured Synonym
PO_POSITION_CONTROLS

PO_POSITION_CONTROLS Secured Synonym
PO_QUOTATION_APPROVALS

PO_QUOTATION_APPROVALS Secured Synonym
PO_RELEASES

PO_RELEASES Secured Synonym
PO_RELEASES_ARCHIVE

PO_RELEASES_ARCHIVE Secured Synonym
PO_REQEXPRESS_HEADERS

PO_REQEXPRESS_HEADERS Secured Synonym
PO_REQEXPRESS_LINES

PO_REQEXPRESS_LINES Secured Synonym
PO_REQUISITIONS_INTERFACE

PO_REQUISITIONS_INTERFACE Secured Synonym
PO_REQUISITION_HEADERS

PO_REQUISITION_HEADERS Secured Synonym
PO_REQUISITION_LINES

PO_REQUISITION_LINES Secured Synonym
PO_REQ_DISTRIBUTIONS

PO_REQ_DISTRIBUTIONS Secured Synonym
PO_REQ_DIST_INTERFACE

PO_REQ_DIST_INTERFACE Secured Synonym
PO_SYSTEM_PARAMETERS

PO_SYSTEM_PARAMETERS Secured Synonym
PO_UNIQUE_IDENTIFIER_CONTROL

PO_UNIQUE_IDENTIFIER_CONTROL Secured Synonym
E-Business Tax
PO_REQ_TAX_LINES_SUMMARY_V
 E-Business Tax Integration

 PO_REL_TAX_LINES_SUMMARY_V
 E-Business Tax Integration

 PO_TAX_LINES_SUMMARY_V
 E-Business Tax Integration

10.Receivables



10.1 New Tables

Table Name
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

10.2 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
 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.

10.3 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

 

10.4 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

 

10.5 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


11.Payables


            New Tables

Table Name                                 
 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



 

            Changed Tables

Table Name 
 Feature Area 
 Brief Description of Change
AP_INVOICES_ALL
 Invoice Lines, eBusiness Tax, Payments, SLA, Complex Work POs…
 Numerous 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.

 

            Obsolete Tables

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

 

            New Views

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.

 

            Changed Views

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

 

            Obsolete Views

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

            TCA Changes for Suppliers

New Tables
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


Posted by at 1 comment:
Subscribe to: Posts (Atom)