R12 – Table/View Changes, Additions

Technical Document

R12 – Table/View Changes, Additions

Note:Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents.  When you change any of these values, be careful not to accidentally delete the bookmark.  You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region.

Contents

1.    General Ledger 5

1.1 New Tables 5

1.2 Changed Tables 7

2.3 Obsolete Tables 9

2.4 New Views 13

2.5 Changed Views 15

2.6 Obsoleted Views 15

2.    iExpenses 17

2.1 New Tables 17

2.2 Changed Tables 18

2.3 Obsolete Tables 25

2.4 New Views 26

2.5 Changed Views 26

2.6 Obsoleted Views 27

3.    Cash Management (CE) 27

3.1 New Tables 27

3.2 Changed Tables 28

3.3 Obsolete Tables 30

3.4 New Views 30

3.5 Changed Views 32

3.6 Obsoleted Views 37

4.    iReceivables 38

4.1 New Tables 38

4.2 Changed Tables 39

4.3 Obsolete Tables 39

4.4 New Views 40

4.5 Changed Views 40

4.6 Obsolete Views 41

5.    Fixed Assets 41

5.1 New Tables 41

5.2 Changed Tables 42

5.3 Obsolete Tables 43

5.4 New Views 43

5.5 Changed Views 44

5.6 Obsolete Views 44

6.    Projects 44

6.1 New Tables 44

6.2 Changed Tables 45

6.3 Obsolete Tables 45

6.4 New Views 45

6.5 Changed Views 45

6.6 Obsolete Views 47

7.    Tax 47

7.1 New Tables 47

7.2 Changed Tables 47

7.3 Obsolete Tables 48

7.4 New Views 49

7.5 Changed Views 49

7.6 Obsolete Views 50

8.    iProcurement 52

8.1 New Tables 52

8.2 Changed Tables 53

8.3 Obsolete Tables 54

8.4 New Views 55

8.5 Changed Views 55

8.6 Obsolete Views 56

9. Purchasing_ 56

9.1 New Tables 56

9.2 Changed Tables 58

9.3 Obsoleted Tables 69

9.4 New Views 69

9.5 Changed Views 71

9.6 Obsoleted Views 80

10. Receivables 83

10.1 New Tables 83

10.2 Changed Tables 83

10.3 Obsolete Tables 84

10.4 New Views 86

10.5 Changed Views 87

11. Payables 90

11.1     New Tables 90

11.2     Changed Tables 91

11.3     Obsolete Tables 92

11.4     New Views 94

11.5     Changed Views 94

11.6     Obsolete Views 95

11.7     TCA Changes for Suppliers 95

12. HRMS

    12.1  New Tables ____________________________________________________________

      12.2 Changed Tables _______________________________________________________________________________________

      12.3 New Views _____________________________________________________________

   
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

  

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

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

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

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

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

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

 

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

12.    HRMS

 

 

12.1 New Tables

Table Name	Feature Area
PER_CHECKLISTS	Checklists
PER_TASK_IN_CHECKLIST	Checklists
PER_BEN_IDENTIFIED_EVENTS	Checklists
PER_ALLOCATED_CHECKLISTS	Checklists
PER_ALLOCATED_TASKS	Checklists
PAY_XLA_EVENTS	Pay
HR_PERSON_DEPLOYMENTS	Workforce Sourcing and Deployment
HR_PERSON_DEPLYMT_CONTACTS	Workforce Sourcing and Deployment
HR_PERSON_DEPLYMT_EITS	Workforce Sourcing and Deployment
PER_ABSENCE_CASES	Absences

12.2 Changed Tables

                 

Table Name	Feature Area	Brief Description of Change
PER_ABSENCE_ATTENDANCE_TYPES	Absences	The table contains a new column called ABSENCE_OVERLAP_FLAG.
PAY_ZA_ACB_USER_GEN_NOS	South Africa Localization	The USER_CODE column data type has been changed to VARCHAR2 from NUMBER.
Hr_org_info_types_by_class	Operating Unit Support in Core HR	The enabled_flag column has been added. The column is mandatory, its data type is varchar2(30) and has a default value of 'Y'.
PER_ABSENCE_ATTENDANCES	Absences	Modified the definition of this table and added new column Absence Case ID as foreign key to PER_ABSENCE_CASES.absence_case_id.
PAY_UPGRADE_LEGISLATIONS	Australia Localization	Inserted the SINGLE_BAL_TABLE rule to enable single latest balance support.
PAY_RETRO_DEFINITIONS	Australia Localization	Inserted the AU_RETROPAY definition to support enhanced retro pay.
PAY_RETRO_COMPONENTS	Australia Localization	Inserted row for the Backdated Changes component to support Enhanced Retro Pay.
PAY_RETRO_EFN_COMPONENTS	Australia Localization	Inserted row for Backdated Changes.
PAY_TIME_DEFINITIONS	Australia Localization	Inserted rows for the following time definitions: START_OF_TIME END_OF_12_MONTHS START_OF_PREV_LT12 END_OF_PREV_YEAR START_OF_CURRENT_YEAR END_OF_TIME
PAY_TIME_SPANS	Australia Localization	Inserted rows for the following time definitions: START_OF_PREV_LT12 START_OF_CURRENT_YEAR
PAY_REPORT_FORMAT_PARAMETERS	Australia Localization	Modified to turn on the View Results button on PAYWSACT.
		Modified to enable Payslip Archive from the Quick Pay form.
		Modified to enable Once Each Period Flag on Element Types.
		Modified to enable ACTION_INFORMATION9 to be picked in the pay_employee_action_info_v view.
PAY_LEGISLATIVE_FIELD_INFO	Australia Localization	Modified to turn on the View Results button on PAYWSACT.
		Modified to enable Payslip Archive from the Quick Pay form.
		Modified to enable Once Each Period Flag on Element Types.
		Modified to enable ACTION_INFORMATION9 to be picked in the pay_employee_action_info_v view.

12.3 New Views

 

 

 

View Name	Feature Area s
PAY_XLA_COST_ACTIONS_V	Pay
PAY_XLA_COSTS_V	Pay
PAY_XLA_EST_OR_PAYM_ACTIONS_V	Pay
PAY_XLA_ESTIMATE_COSTS_V	Pay
PAY_XLA_PAYMENT_COSTS_V	Pay
PER_BUSINESS_GROUP_NAME	Workforce Sourcing and Deployment
PAY_JP_PRE_TAX	Japan Localization
HR_ORG_OU_V	Operating Unit WebADI Upload

 

 

 

 

12.4 Changed Views

View Name	Feature Area	Brief Description of Change
PER_ABS_ATTENDANCE_TYPES_VL	Absences	The view contains a new column called ABSENCE_OVERLAP_FLAG.
PER_ABS_ATTENDANCE_TYPES_V	Absences	The view contains a new column called ABSENCE_OVERLAP_FLAG.
per_all_organization_units	Operating Unit Support in Core HR	The view contains an operating_unit_id column. The view is delivered in the persleo.odf file.
per_organization_units	Operating Unit Support in Core HR	The view contains an operating_unit_id column. The view is delivered in the persleo.odf file.
PER_ABSENCE_ATTENDANCES_V3	Absences	The view contains a new column Absence_case_id selecting it from PER_ABSENCE_ATTENDANCES table.
PAYBV_JP_PRE_TAX_V	Japan Localization	Used for Adhoc reports. Business layer view for PAY_JP_PRE_TAX table.
PAYBV_JP_SWOT_NUMBERS_V	Japan Localization	Used for Adhoc reports. Business layer view PAY_JP_SWOT_NUMBERS table.
PAY_JP_ADJ_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_BAL_MATRIX_BY_ACT_V	Japan Localization	Used as one of the base views of PAYJPBAL form. Columns BALANCE_UOM, D_BALANCE_UOM, and CURRENCY_CODE have been added, and PAYROLL_ACTION_ID and ASSIGNMENT_ACTION_ID have been removed. Performance tuned.
PAY_JP_BAL_MATRIX_BY_DATE_V	Japan Localization	Used as one of the base views of PAYJPDMW form. Columns BALANCE_UOM, D_BALANCE_UOM, and CURRENCY_CODE are added, and ROW_ID, PAYROLL_ACTION_ID, ASSIGNMENT_ACTION_ID, and EFFECTIVE_DATE are removed. Performance tuned.
PAY_JP_CI_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_CMA_CAR_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPMA form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_CMA_TRAIN_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPCMA form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_DEPENDS_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_GEPPEN_SANTEI_MT_V	Japan Localization	Used in PAYJPGMT report. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_GEPPEN_SANTEI_V	Japan Localization	Used in PAYJPNGS report. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_HI_BON_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_HI_COMP_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_HI_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_HI_SAL_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_HOUSING_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_INPUT_VALUE_IDS_V	Japan Localization	This view returns social insurance reports related input value ids. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_INSPREMS_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_ITAX_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_LI_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_LTAX_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_NONRESIDENT_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_PAYJPBAL_VALUES_V	Japan Localization	Used as one of the base views of PAYJPBAL form. Columns ELEMENT_NAME, SOURCE_ID, and DISPLAY_ORDER are added, and ASSIGNMENT_ID and BALANCE_NAME are removed.
PAY_JP_PAYJPDMW_VALUES_V	Japan Localization	Used as one of the base views of PAYJPDMW form. Column ELEMENT_NAME, SOURCE_ID, and DISPLAY_ORDER are added, and ROW_ID and BALANCE_NAME are removed.
PAY_JP_PJOB_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_PRE_ITAX_V	Japan Localization	This view is used to get the Archived Tax Information at Assignment Action level by combining Year-End Adjustment salary category (i.e., YEA, RE_YEA) and the other salary categories (like Salary, Bonus, Special Bonus and Termination) provided the future Assignment Actions for Year-End Adjustment salary category do not exist in the same year.
PAY_JP_PRE_ITAX_V1	Japan Localization	This view is used to get the Archived Tax Information at Assignment Action level by combining Year-End Adjustment salary category (i.e., YEA, RE_YEA) and the other salary categories (like Salary, Bonus, Special Bonus and Termination) provided the future Assignment Actions for Year-End Adjustment salary category doesn't exist in the same year.
PAY_JP_PRE_ITAX_V2	Japan Localization	This view is used to derive the maximum Assignment Action, Action Sequence, latest Date Earned and the summation of taxable amounts per year basis for all salary categories except "Termination". This information would be grouped by Business Group, Assignment, Payroll Effective Date and Income Tax Organization.
PAY_JP_PRE_TAX_V	Japan Localization	This view is used to get the complete Archived Tax Information at Assignment Action Level.
PAY_JP_SI_BON_PAYMENT_V	Japan Localization	Used in PAYJPBON and PYAJPFBP reports. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SI_CHANGE_OF_ADDRESS_V	Japan Localization	Used in PAYJPCAD, PAYJPCAW, and PAYJPFAC reports. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SI_DISQUALIFIED_MT_V	Japan Localization	Used in PAYJPSMT report. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SI_DISQUALIFIED_V	Japan Localization	Used in PAYJPFSD, PAYJPSDD, and PAYJPSID reports. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SI_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SI_FD_ACTION_DATE_V	Japan Localization	Used in valuesets related to Social Insurance FD reports. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SI_QUALIFIED_V	Japan Localization	Used in PAYJPFSQ, PAYJPSIQ, and PAYJPSQD reports. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_SP_LTAX_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_TAX_SWOT_V	Japan Localization	Used in PAYJPPRS report. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_TERM_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_UI_BON_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_UI_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_UI_SAL_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_UI_SP_BON_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_UI_V	Japan Localization	Used in PAYJPNUI report. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_WIC_ASSACTS_V	Japan Localization	This view is used to get the Withheld Income Tax information at Assignment Action Level. All Salary Categories except "Termination" would be considered while picking up the data for Withheld Tax.
PAY_JP_WPF_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_WP_BON_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_WP_COMP_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_WP_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_JP_WP_SAL_ENTRIES_V	Japan Localization	Used as one of the base views of PAYJPTAX form. Changed to refer to the new element type name and input value name accompanied with the seed data English conversion.
PAY_AU_ASG_ELEMENT_PAYMENTS_V	Australia Localization	Modified to retrieve the hourly rate to support the Retro Upgrade mechanism.
PAY_AU_SOE_RUN_ELEMENTS_V	Australia Localization	Modified to retrieve the hourly rate to support the Retro Upgrade mechanism.

 

 

 

 

 

12.5 New Workflows

Workflow Name	Feature Area
HR Checklist (HRCKLTSK)	Checklists
HR Checklist Notifier Workflow (HRCKLFYI)	Checklists

 

 

12.6 Changed Workflows

Workflow Name	Feature Area	Brief Description of Change
AU HR PERSON TASKFLOW	Australia Localization	Modified to match the latest global task flow.
AU_HRMS_NAV	Australia Localization	The menu has been modified to match the latest global menus.
AU_HRMS_FASTPATH	Australia Localization	The menu has been modified to match the latest global menus.
AU_HRMS_PEOPLE	Australia Localization	The menu has been modified to match the latest global menus.
AU_HRMS_OTHER	Australia Localization	The menu has been modified to match the latest global menus.

 

 

 

12.7 New Public APIs

 

Public API Name	Feature Area
HR_PERSON_DEPLOYMENT_API . CREATE_PERSON_DEPLOYMENT	Workforce Sourcing and Deployment
HR_PERSON_DEPLOYMENT_API .UPDATE_PERSON_DEPLOYMENT	Workforce Sourcing and Deployment
HR_PERSON_DEPLOYMENT_API .DELETE_PERSON_DEPLOYMENT	Workforce Sourcing and Deployment
HR_PERSON_DEPLOYMENT_API .INITIATE_DEPLOYMENT	Workforce Sourcing and Deployment
HR_PERSON_DEPLOYMENT_API .CHANGE_DEPLOYMENT_DATES	Workforce Sourcing and Deployment
HR_PERSON_DEPLOYMENT_API .RETURN_FROM_DEPLOYMENT	Workforce Sourcing and Deployment
hr_person_absence_case_api.create_person_absence_case	Absences
hr_person_absence_case_api.update_person_absence_case	Absences
hr_person_absence_case_api.delete_person_absence_case	Absences

12.8 Changed Public APIs

Public API Name	Feature Area	Brief Description of Change
Pay_Org_Payment_Method_API	Pay	Allows the selection of the Cash Management Bank Account via the p_bank_account_id
HR_FR_CONTRACT_API.CREATE_FR_CONTRACT	French Localization	Updated with additional parameters pertaining to fixed working time to facilitate maintenance of related segments for the Further Contract Information descriptive flexfield for French legislation.
HR_FR_CONTRACT_API.UPDATE_FR_CONTRACT	French Localization	Updated with additional parameters pertaining to fixed working time to facilitate maintenance of related segments for the Further Contract Information descriptive flexfield for French legislation.
HR_FR_ASSIGNMENT_API.UPDATE_FR_EMP_ASG	French Localization	Updated with additional parameters p_professional_status and p_grouping_employer to facilitate maintenance of related segments for the FR Statutory Info Soft Coded key flexfield.
HR_FR_ASSIGNMENT_API.CREATE_FR_SECONDARY_EMP_ASG	French Localization	Updated with additional parameters p_professional_status and p_grouping_employer to facilitate maintenance of related segments for the FR Statutory Info Soft Coded key flexfield.
hr_absence_type_api	Absences	Added a new parameter p_absence_overlap_flag.
Hrorgapi.pkb/h	Operating Unit Support in Core HR	A new procedure called get_operating_unit has been created to retrieve the operating unit of a worker.
HR_ASSIGNMENT_API.UPDATE_EMP_ASG	Workforce Sourcing and Deployment	Added projected_assignment_end as parameter.

 

 

 

 

 

 

12.8 New Flexfields

Flexfield Name	Feature Area
Additional Allocated checklist Details (DFF)	Checklists
Additional Allocated Task Details (DFF)	Checklists
Action Information DF - GB WNU EDI	UK Localization
EB P45(3) EDI	UK Localization
GB P46 EDI	UK Localization
GB P46 Pension EDI	UK Localization
Further Absence Case Information (PER_ABS_CASE_DEVELOPER_DF)	Absences
Additional Absence Case Details (PER_ABSENCE_CASES)	Absences

 

 

 

 

 

12.9 Changed Flexfields

Flexfield Name	Feature Area	Brief Description of Change
GB EMPLOYEES DETAILS	UK Localization	Added Title (ACTION_INFORMATION14), Date of Birth (ACTION_INFORMATION15), Hire Date (ACTION_INFORMATION16), Sex (ACTION_INFORMATION17) and Job Title (ACTION_INFORMATION18). All the new fields are optional.
Org Developer DF	India Localization	A new context PER_IN_FORM24Q_RECEIPT_DF has been added.
Action Information DF	India Localization	This flexfield now contains the following new contexts: ·  IN_24QC_ORG ·  IN_24QC_CHALLAN ·  IN_24QC_DEDUCTEE A new segment has been included in the following contexts: IN_24Q_ORG IN_24Q_CHALLAN IN_24Q_DEDUCTEE
IN_STATUTORY_INFO	India Localization	A new segment called PF/EPS Contribution has been added.

Profile Options

12.10 New Profile Options

Profile Option Name	Feature Area
HR: Display Special Rate Annual Income on Assignment	Netherlands Localization
BEN: CWB Worksheet Rows Displayed	Compensation Workbench
BEN: CWB Budgets Rows Displayed	Compensation Workbench
BEN: CWB Spreadsheet Version	Compensation Workbench
BEN: CWB Budget as Percent of Eligible Salary Decimals	Compensation Workbench
BEN: CWB Allocation as Percent of Eligible Salary Decimals	Compensation Workbench

12.11 New Reports

Report Name	Function Name
Form 24Q corrections (PYIN24CR)	N/A

 

 

12.12 Changed Reports

Report Name	Function Name	Brief Description of Change
End of Reconciliation Detail Report (PYAURECD)	N/A	Modified the report to support the Retro Upgrade mechanism.
Pay Advice (PYAUPSSP)	N/A	Modified the report to support the Retro Upgrade mechanism.

12.13 New XML Publisher Components

Definition Name	Template Name	Concurrent Program
Payroll Extract Process	PAYEXTRACT.rtf	Payroll Extract Process
Payroll Compare Process	PAYCOMPARE.rtf	Payroll Compare Process

12.14 Changed XML Publisher Components

Definition Name	Template Name	Concurrent Program	Brief Description of Change
PAY_IN_PT_FORM3	PYINPTX3_en_US.rtf	India PT Form III for Maharashtra	The PT Form 3 report has been modified to include format changes for Statutory update 1-Apr-06.

13. XML Publishers:

13.1 New HTML Pages

HTML Page Name	Function Name
Configuration	XDO: Configuration - Update
Font Files	XDO: Font Files Home
Create/Update Font File	XDO: Font File - Update
Currency Format Sets	XDO: Currency Formats Home
Create/Update Currency Format Sets	XDO: Currency Format Set Update
Add/Update Currency Format	XDO: Currency Format Update
Font Mappings	XDO: Font Mappings Home
Create/Update Font Mapping Sets	XDO: Font Mapping Set Update
Create/Update Font Mapping	XDO: Font Mapping Update
View Currency Format Set	XDO: View Currency Formats
View Font Mapping Set	XDO: View Font Mappings
Update Font Mapping (Target font page)	XDO: Font Mapping Update Target
Add Translation	XDO: Template - Translate

 

 

 Changed User Interfaces

13.2 Changed HTML Pages

HTML Page Name	Function Name	Brief Description of Change
View Data Definition	XDO: Data Definition - Update	Added field to upload data template, added buttons to go to upload data template file page.  Added button to set the configuration properties at the data definition level.
Update/Create Data Definition	XDO: Data Definition - Update	It’s no longer possible to update/upload files on this page.  User must upload files from a separate page.
View Template	XDO: Template - Detail	Template files divided between Localized and Translatable templates.  Shows Available translations.  Added button to set the configuration properties at the template level.
Update Template	XDO: Template General Information	Can change the base translatable locale.
Create Template	XDO: Template General Information	Can specify whether the template file is translatable.
Add Template File	XDO: Template File - Add	Can specify whether the template file is translatable.

 

 

 

 

13.3 New Public APIs

Public API Name	Feature Area
oracle.apps.xdo.dataengine	DataTemplate/DataEngine DataProcessor Parameter
oracle.apps.xdo.template	EFT FTGeneratorProcessor EFTINProcessor
oracle.apps.xdo.template.pdf.book	Book Binder OutlineProcessor PDFBookBinder PDFOverlay PDFReportBinder
oracle.apps.xdo.template.pdf.js	PDF Utilities JavascriptEditor
oracle.apps.xdo.oa.util	DataTemplate DataTemplate
oracle.apps.xdo.oa.common	XDO Common Region DocumentHelper

 

 

 

 

 

13.4 New Tables

Table Name	Feature Area
xdo_config_keys	Configuration properties
xdo_config_properties_b	Configuration properties
xdo_config_properties_tl	Configuration properties
xdo_config_values	Configuration properties
xdo_currency_format_sets_b	Currency formats
xdo_currency_format_sets_tl	Currency formats
xdo_currency_formats	Currency formats
xdo_eft_sequence_names	E-text template processing
xdo_font_mapping_sets_b	Font mappings
xdo_font_mapping_sets_tl	Font mappings
xdo_font_mappings	Font mappings
xdo_trans_unit_props	Template translation
xdo_trans_unit_values	Template translation
xdo_trans_units	Template translation

 

 

 

13.5 Changed Tables

Table Name	Feature Area	Brief Description of Change
xdo_lobs	XDO files	Added column to indicate whether the translation is complete.
xdo_templates_b	Templates	Added columns to indicate the base translatable locale.

 

Views

13.6 New Views

View Name	Feature Area
xdo_config_properties_vl	Configuration properties
xdo_font_mapping_sets_vl	Font mappings
xdo_currency_format_sets_vl	Currency formats

 

 

 

 

13.7 Changed Views

View Name	Feature Area	Brief Description of Change
xdo_templates_vl	Templates	Added columns to indicate base translatable locale.

14. TCA

14.1 New Tables

Table Name	Feature Area
HZ_ADAPTER_USERS	This table is used for third party integration.
HZ_ADDRESS_USAGE_DTLS	This table stores the required geography components for address usages per country and address style.
HZ_ADDRESS_USAGES	This table stores the address usages per country and address style.  Address usage is used during Geography Name Referencing (GNR) process to identify the required geography components in order for an address to pass GNR process for that address usage.
HZ_BES_GT	This is a session specific global temporary table. When Raise Events concurrent program runs, this table stores the potential business object identifiers for raising events.
HZ_BUS_OBJ_DEFINITIONS	This table stores business object definitions.  Seeded business object definition will be shipped with R12 release.
HZ_BUS_OBJ_TRACKING	This table stores transactions of business objects. For example, data is written to this table when an organization is created.  Insert/update transaction on all business objects/entities from Oracle Customer Online, forms, V2 APIs, and business object APIs are tracked in this table.
HZ_DQM_SETUP_DIAGNOSTICS	This table stores all the DQM setup diagnostic reports and their information.
HZ_SHADOW_ST_CONTACTS	This table is a replica of  HZ_STAGED_CONTACTS.
HZ_SHADOW_ST_CPTS	This table is a replica of  HZ_STAGED_CONTACT_POINTS.
HZ_SHADOW_ST_PARTIES	This table is a replica of  HZ_STAGED_PARTIES.
HZ_SHADOW_ST_PSITES	This table is a replica of  HZ_STAGED_PARTY_SITES.
HZ_THIN_ST_CONTACTS	This table is a condensed form of HZ_STAGED_CONTACTS without all the staged columns.
HZ_THIN_ST_CPTS	This table is a condensed form of HZ_STAGED_CONTACT_POINTS without all the staged columns.
HZ_THIN_ST_PARTIES	This table is a condensed form of HZ_STAGED_PARTIES without all the staged columns.
HZ_THIN_ST_PSITES	This table is a condensed form of HZ_STAGED_PARTY_SITES without all the staged columns.

14.2 Changed Tables

Table Name	Feature Area	Brief Description of Change
AR_CUSTOMER_PROFILES	Customer Profile	Obsolete Indexes: AR_CUSTOMER_PROFILES_N1
HZ_CUST_ACCOUNTS	Customer Accounts	Obsolete Columns: ACCOUNT_ACTIVATION_DATE ACCOUNT_TERMINATION_DATE CURRENT_BALANCE ACCT_LIFE_CYCLE_STATUS DORMANT_ACCOUNT_FLAG REALTIME_RATE_FLAG ACCOUNT_LIABLE_FLAG DEPARTMENT COMPETITOR_TYPE SUSPENSION_DATE NOTIFY_FLAG ORDER_TYPE_ID PRIMARY_SALESREP_ID TAX_CODE ORDER_TYPE_ID, PRIMARY_SALESREP_ID and TAX_CODE are organization sensitive columns. They are usable at the customer level only in a non-multi-org environment. These columns are obsolete because users must upgrade to multi-org in Release 12. Migration scripts are provided to move the values from the customer account level to site level, when the customer converts from non-multi-orgto multi-org.
HZ_CUST_ACCT_RELATE_ALL	Customer Accounts	Added CUST_ACCT_RELATE_ID column as a primary key. This is required by auditing.
HZ_CUST_ACCT_SITES_ALL	Customer Account Sites	LANGUAGE column is obsolete because it is a duplicate of HZ_LOCATIONS.LANGUAGE.
HZ_CUST_PROFILE_AMTS	Customer Profiles	Added columns for Oracle Receivables enhancements for Balance Forward Billing and Late Charges: EXCHANGE_RATE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_PERCENTNUMBER MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_PERCENTNUMBER INTEREST_TYPE INTEREST_FIXED_AMOUNTNUMBER INTEREST_SCHEDULE_ID PENALTY_TYPE PENALTY_RATENUMBER MIN_INTEREST_CHARGENUMBER PENALTY_FIXED_AMOUNTNUMBER PENALTY_SCHEDULE_ID
HZ_CUST_PROFILE_AMTS	Customer Profiles	Obsolete Indexes: HZ_CUST_PROFILE_AMTS_N1
HZ_CUSTOMER_PROFILES	Customer Profiles	Added columns for Oracle Receivables enhancements for Balance Forward Billing and Late Charges: CONS_BILL_LEVEL LATE_CHARGE_CALCULATION_TRX CREDIT_ITEMS_FLAG DISPUTED_TRANSACTIONS_FLAG LATE_CHARGE_TYPE LATE_CHARGE_TERM_ID INTEREST_CALCULATION_PERIOD HOLD_CHARGED_INVOICES_FLAG MESSAGE_TEXT_ID MULTIPLE_INTEREST_RATES_FLAG CHARGE_BEGIN_DATE
HZ_DQM_STAGE_GT	Data Quality Management	New column PERSON_PARTY_ID added.
HZ_GEO_NAME_REFERENCE_LOG	Geography Name Referencing	Added column USAGE_CODE (VARCHAR2(30)).
HZ_GEO_STRUCTURE_LEVELS	Geography Hierarchy	Added column ADDR_VAL_LEVEL (VARCHAR2 (60)). Address validation level is specific to a country and value for ADDR_VAL_LEVEL should be set only at country level.
HZ_LOC_ASSIGNMENTS	Locations	Obsolete Indexes: HZ_LOC_ASSIGNMENTS_U1
HZ_LOCATIONS	Locations	Obsolete Columns: PO_BOX_NUMBER HOUSE_NUMBE STREET_SUFFIX STREET STREET_NUMBER FLOOR SUITE Columns are obsolete because address lines 1-4 are not parsed, so these columns are not populated.
HZ_MATCH_RULES_B	DQM Match Rules	Added new columns USE_CONTACT_ADDR_FLAG and USE_CONTACT_CPT_FLAG.
HZ_MERGE_ENTITY_ATTRIBUTES	Merge	Obsolete Indexes: HZ_MERGE_ENTITY_ATTRIBUTES_N1
HZ_ORG_CONTACTS	Organization Contacts	TITLE is obsolete because it is a duplicate column of  HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT.
HZ_ORGANIZATION_PROFILES	Organization Profiles	HOME_COUNTRY column is added in HZ_ORGANIZATION_PROFILES table and denormalized into HZ_PARTIES table. This is a dedicated column for the country of the bank as validations are country specific.
HZ_ORIG_SYS_REFERENCES	Source System Management	New HZ_ORIG_SYS_REFERENCES_N3 index added to improve performance.
HZ_PARTIES	Parties	Obsolete Indexes (for performance reasons): HZ_PARTIES_N6 HZ_PARTIES_N9 Rewrite any queries that use index HZ_PARTIES_N6 or HZ_PARTIES_N9 to use HZ_PARTIES_N1 (index on HZ_PARTIES.PARTY_NAME) in place of HZ_PARTIES_N6, and HZ_PARTIES_N5 (functional index on HZ_PARTIES.UPPER(PARTY_NAME)) in place of HZ_PARTIES_N9. HOME_COUNTRY added in HZ_ORGANIZATION_PROFILES table and denormalized into HZ_PARTIES table. New Columns (provide significant performance benefit when determining the appropriate events to raise): PERSON_BO_VERSION ORG_BO_VERSION PERSON_CUST_BO_VERSION ORG_CUST_BO_VERSION These columns should .
HZ_PARTY_SITES	Party Sites	LANGUAGE is obsolete because it is a duplicate column of HZ_LOCATIONS. LANGUAGE. New column DUNS_NUMBER_C will be for internal use only and is exposed only in TCA Party Site API without any validations. Oracle Payabes populates this column during Supplier upgrade to TCA and JFMIP/Federal integration leverages this column.
HZ_STAGED_CONTACT_POINTS	DQM Staging	New columns PERSON_PARTY_ID, QKEY added.
HZ_STAGED_CONTACTS	DQM Staging	New column QKEY added.
HZ_STAGED_PARTY_SITES	DQM Staging	New columns PERSON_PARTY_ID, QKEY added.
HZ_WORD_REPLACEMENTS	DQM Word Replacements	New columns DELETE_FLAG and STAGED_FLAG.
JTF_RS_SALESREPS	Salesperson in Resource Manager	Default value for ORG_ID has been removed.
RA_CUSTOMER_MERGE_HEADERS	Customer Merge	Added ORG_ID NUMBER column.
RA_CUSTOMER_MERGES	Customer Merge	Added ORG_ID NUMBER column.

14.3 Obsoleted Tables

Table Name	Feature Area	Replaced By
HZ_CUST_CONTACT_POINTS	Contact Points in Account Level	HZ_CONTACT_POINTS
HZ_INDUSTRIAL_CLASSES	Industrial Classes	Classification Model
HZ_INDUSTRIAL_CLASS_APP	Industrial Class Application	Classification Model
HZ_LOC_ASSIGNMENTS	Address Validation	None
HZ_PARAM_TAB	Old CRM user hook mechanism allowed teams to do additional processing by raising events when data was manipulated. The subscriptions to those events performed the actual product logic. This process also populated HZ_PARAM_TAB table with the old and new version of the changed record; this data could then be used by the procedures. The mechanism caused significant performance issues as the table quickly grows large.	None

 

Views

14.4 New Views

View Name	Feature Area
JTF_RS_DEFRESOURCES_V	Retrieves resource details for the Define Resource page in Define Resource Form.
JTF_RS_DEFRESOURCES_SRP_V	Retrieves salesperson details for the Receivables tab in Define Resource form.

14.5 Changed Views

View Name	Feature Area	Brief Description of Change
JTF_RS_DEFRESOURCES_VL	Resource Manager	Removed Client Info predicate from the Where Clause of the view.
JTF_RS_RESOURCE_DTLS_VL	Resource Manager	Removed Client Info predicate from the Where Clause of the view.
JTF_RS_ALL_RESOURCES_VL	Resource Manager	Added ORG_ID and ORG_NAME colums in this view since it returns multiple records for salespersons in different operating units.
JTF_RS_RESOURCES_VL	Resource Manager	Added ORG_ID and ORG_NAME columsn in this view since it returns multiple records for salespersons in different operating units.

14.6 Obsoleted Views

View Name	Feature Area	Replaced By
HZ_CUST_ACCT_SITES	Account Sites	Multi-Org Synonym HZ_CUST_ACCT_SITES
HZ_CUST_SITE_USES	Account Site Uses	Multi-Org Synonym HZ_CUST_SITE_USES
HZ_CUST_ACCT_RELATE	Account Relationship	Multi-Org Synonym HZ_CUST_ACCT_RELATE
RA_CUSTOMERS_INTERFACE	Customer Interface	Multi-Org Synonym RA_CUSTOMERS_INTERFACE
RA_CUSTOMER_PROFILES_INTERFACE	Customer Interface	Multi-Org Synonym RA_CUSTOMER_PROFILES_INTERFACE
RA_CONTACT_PHONES_INTERFACE	Customer Interface	Multi-Org Synonym RA_CONTACT_PHONES_INTERFACE
RA_CUSTOMER_BANKS_INTERFACE	Customer Interface	Multi-Org Synonym RA_CUSTOMER_BANKS_INTERFACE
RA_CUST_PAY_METHOD_INTERFACE	Customer Interface	Multi-Org Synonym RA_CUST_PAY_METHOD_INTERFACE
RA_HCUSTOMERS	Backward compatible view for Accounts. Corresponding synonym is RA_CUSTOMERS	HZ_PARTIES and HZ_CUST_ACCOUNTS
RA_SITE_USES_MORG	Backward compatible view for Account Site Uses. Corresponding synonym is RA_SITE_USES_ALL  & RA_SITE_USES.	HZ_CUST_SITE_USES_ALL / HZ_CUST_SITE_USES
RA_ADDRESSES_MORG	Backward compatible view for Account Sites. Corresponding synonym is RA_ADDRESSES_ALL  and RA_ADDRESSES.	HZ_PARTY_SITES, HZ_LOC_ASSIGNMENTS, HZ_LOCATIONS,  HZ_CUST_ACCT_SITES_ALL / HZ_CUST_ACCT_SITES
RA_HCONTACTS	Backward compatible view for Account Contacts. Corresponding synonym is RA_CONTACTS.	HZ_CUST_ACCOUNT_ROLES, HZ_PARTIES, HZ_RELATIONSHIPS, HZ_ORG_CONTACTS, HZ_CUST_ACCOUNTS
RA_CUSTOMER_RELATIONSHIPS_MORG	Backward compatible view for Account Relationships. Corresponding synonym is RA_CUSTOMER_RELATIONSHIPS_ALL and RA_CUSTOMER_RELATIONSHIPS.	HZ_CUST_ACCT_RELATE_ALL / HZ_CUST_ACCT_RELATE
AR_HCUSTOMER_PROFILES	Backward compatible view for Customer Profiles. Corresponding synonym is AR_CUSTOMER_PROFILES.	HZ_CUSTOMER_PROFILES
AR_HCUSTOMER_PROFILE_AMOUNTS	Backward compatible view for Customer Profile Amounts. Corresponding Synonym is AR_CUSTOMER_PROFILE_AMOUNTS.	HZ_CUST_PROFILE_AMTS
AR_HCUSTOMER_PROFILE_CLASSES	Backward compatible view for Customer Profile Classes. Corresponding synonym is AR_CUSTOMER_PROFILE_CLASSES.	HZ_CUST_PROFILE_CLASSES
AR_HCUST_PROF_CLASS_AMOUNTS	Backward compatible view for Customer Profile Class Amounts. Corresponding synonym is  AR_CUST_PROF_CLASS_AMOUNTS .	HZ_CUST_PROF_CLASS_AMTS
RA_HCONTACT_ROLES	Backward compatible view for Contact Roles. Corresponding Synonym is  RA_CONTACT_ROLES.	HZ_ROLE_RESPONSIBILITY
RA_HPHONES	Backward compatible view for Phones. Corresponding synonym is  RA_PHONES.	HZ_CONTACT_POINTS and HZ_CUST_ACCOUNT_ROLES
HZ_PARTY_RELATIONSHIPS	Backward compatible view for Relationships.	HZ_RELATIONSHIPS
HZ_CONTACT_RESTRICTIONS	Backward compatible view for Contact Preferences.	HZ_CONTACT_PREFERENCES
JTF_RS_SALESREPS_MO_V	Single Org view for Salesreps in Resource Manager.	Multi-Org Synonym JTF_RS_SALESREPS_MO_V

 

Synonyms with Policies

14.7 New Synonyms with Policies

Synonym Name	Policy Name	Package Name	Function Name	DML Operations (Select, Update, Insert, Delete)
HZ_CUST_ACCT_SITES	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
HZ_CUST_SITE_USES	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
HZ_CUST_ACCT_RELATE	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
RA_CUSTOMERS_INTERFACE	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
RA_CUSTOMER_PROFILES_INTERFACE	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
RA_CONTACT_PHONES_INTERFACE	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
RA_CUSTOMER_BANKS_INTERFACE	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
RA_CUST_PAY_METHOD_INTERFACE	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete
JTF_RS_SALESREPS_MO_V	ORG_SEC	MO_GLOBAL	ORG_SECURITY	Select, Update, Insert, Delete