Oracle R12 TableView Changes
Oracle R12 TableView Changes
Oracle R12 TableView Changes
Technical Document
For Documents on Oracle ERP Topics keep visiting our Site for Oracle ERP Networking … http://www.OracleERP.org
Contents
12. HRMS
12.1 New Tables ____________________________________________________________
12.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
None of the obsolete tables have been dropped. Some obsolete tables have been renamed with the suffix _11i. Some obsolete
tables are highlighted below.
A number of new views have been added to support UIs and processing of new features. Some of the views are mentioned
below.
GL_SUMMARY_BC_OPTIONS_V Summarization
GL_SUMMARY_TEMPLATES_V Summarization
GL_TRANSLATION_RATES Revaluation, Translation and
Conversion Rates
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.
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
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
• LOCATION_TYPE
• COUNTRY
• STATE_PROVINCE_ID
• COUNTY_ID
• CITY_LOCALITY_ID
Modified Column:
• CARD_ID - References
AP_CARDS_ALL.CARD_ID
Modified Column:
• 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.
Feature Area Brief Description of Change
Table Name
• 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.
• AMOUNT
• PROJECT_ID
• TASK_ID
• AWARD_ID
• EXPENDITURE_ORGANIZATION_ID
• COST_CENTER
• SET_OF_BOOKS_ID
Feature Area
Replaced By
Table Name
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
Feature Area
View Name
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
Feature Area
View Name
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
Feature Area
View Name Brief Description of Change
CE_101_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_101_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_185_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_185_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and
Reconciliation Subledger Accounting and Bank Account
Model features
CE_200_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
Feature Area
View Name Brief Description of Change
CE_200_BATCHES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_200_REVERSAL_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_200_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_222_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_222_BATCHES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_222_REVERSAL_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_222_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_222_TXN_FOR_BATCH_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_260_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_260_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_801_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_801_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_801_EFT_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
Feature Area
View Name Brief Description of Change
CE_801_EFT_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_999_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_999_RECONCILED_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_999_REVERSAL_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_ALL_STATEMENTS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_ARCH_RECONCILIATIONS Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_AVAIL_STATEMENTS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_AVAILAVLE_BATCHES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_AVAILAVLE_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_BANK_TRX_CODES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_INTERNAL_BANK_ACCOUNTS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_MISC_TAX_CODE_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_MISC_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
Feature Area
View Name Brief Description of Change
CE_RECEIVABLE_ACTIVITIES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_RECONCILED_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_REVERSAL_TRANSACTIONS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_STAT_HDRS_INF_V Bank Statement Enhancement related to MOAC, Balances
Reconciliation and Interests Calculation and Bank
Account Model feature
CE_STATEMENT_HEADERS_V Bank Statement Enhancement related to MOAC, Balances
Reconciliation and Interests Calculation and Bank
Account Model features
CE_STATEMENT_LINES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_STATEMENT_RECONCILIATIONS Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_SYSTEM_PARAMETERS Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_SYSTEM_PARAMETERS_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation Account Model features
CE_TRANSACTION_CODES_V Bank Statement Enhancement related to MOAC and Bank
Reconciliation 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
Feature Area
View Name Brief Description of Change
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 Enhancement related to Bank Statement
Reconciliation 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
3. iReceivables
Feature Area
Table Name
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
Feature Area
View Name
ARI_CUSTOMER_SEARCH_V Customer search for internal
users
4. Fixed Assets
5.1 New Tables
CSI_FA_HEADERS Notification Process This table captures asset related information about Fixed assets that are
for newly added manually added using the Assets Workbench – The generated data is
assets. then used in the Generate Notification concurrent process.
CSI_FA_TRANSACTIONS Notification Process This table captures transactional information about Fixed assets that are
for newly added manually added using the Assets Workbench – The generated data is
assets. then used in the Generate Notification concurrent process.
CSI_I_ASSET_INTERFACE Open Interface for This table if loaded with the instance and asset link information will be
Instance to Fixed used by the “Install Base Open Interface” program to create the
Asset Association association between the item instance and the fixed asset.
Feature Area
Table Name Brief Description of Change
CSI_I_ASSET_TXN_TEMP Improved This table was used to temporarily hold data before creating
Integration with assets in FA. Primarily used for grouping purpose. The
Fixed Asset grouping logic is now handled in the code.
5. Projects
None
6. Tax
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.
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. iProcurement
None.
None.
None.
9. Purchasing
Feature Area
Table Name
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
Feature Area
Table Name
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
Feature Area
Table Name
PO_ATTR_VALUES_INTERFACE Interface table for line non-translatable
attribute values
PO_ATTR_VALUES_TLP_INTERFACE Interface table for line translatable
attribute values
Feature Area
Brief Description of Change
Table Name
Professional Buyer’s Work Center
PO_HEADERS_ALL PO Added columns (SUPPLIER_NOTIF_METHOD,
Communication FAX, EMAIL_ADDRESS) for capturing the
Details Communication Details specified for a PO on the
Create/Update Order page.
PO_HEADERS_ARCHIVE_ALL PO As above.
Communication
Details
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
Feature Area
Brief Description of Change
Table Name
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 Added the STYLE_ID column for capturing the style
Styles of each document.
Feature Area
Brief Description of Change
Table Name
PO_HEADERS_ARCHIVE_ALL Document As above.
Styles
PO_HEADERS_INTERACE Document As above.
Styles
Procurement for Complex Services
PO_LINES_ALL Complex Work Addition of the following Columns :
Procurement
• 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)
E-Business Tax
PO_HEADERS_ALL E-Business Tax Added column tax_attribute_update_code
Integration
PO_LINES_ALL E-Business Tax Added column tax_attribute_update_code
Integration
PO_LINE_LOCATIONS_ALL E-Business Tax Added columns tax_attribute_update_code and
Integration original_shipment_id
PO_DISTRIBUTIONS_ALL E-Business Tax Added column tax_attribute_update_code
Integration
PO_REQUISITION_HEADERS_ALL E-Business Tax Added column tax_attribute_update_code
Integration
PO_REQISITION_LINES_ALL E-Business Tax Added columns tax_attribute_update_code and
Integration tax_name
PO_RELEASES_ALL E-Business Tax Added column tax_attribute_update_code
Integration
PO_REQUISITIONS_INTERFACE_ALL E-Business Tax Added column tax_name
Feature Area
Brief Description of Change
Table Name
Integration
Communicate Document Attachments to Suppliers
PO_SYSTEM_PARAMETERS_ALL Zipped file Added columns (MAX_ATTACHMENT_SIZE and
attachments 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 Added columns (MAX_ATTACHMENT_SIZE and
attachments in EMAIL_ATTACHMENT_FILENAME) for
Purchasing capturing the details regarding the zip file generated
Options Page for the file attachments
Uptake Subledger Accounting for Funds Control
PO_ENCUMBRANCE_GT SLA: Uptake Added new columns like value_basis, payment_type
Subledger to accommodate Complex Work uptake and
Accounting for entered_amount, gl_period_date to accommodate new
Funds Control requirements for SLA.
PO_ONLINE_REPORT_TEXT SLA: Uptake Added the columns show_in_psa_flag, segment1,
Subledger distribution_type to add support for reporting PO
Accounting for errors through the new SLA OA page(PSA:
Funds Control Budgetary Control Results Page).
Purchase Document Open Interface Enhancements
PO_HEADERS_INTERFACE PDOI Add columns to support catalog upload as well as
Processing PDOI bulk processing
PO_LINES_INTERFACE PDOI Add columns to support catalog upload as well as
Processing PDOI bulk processing
Feature Area
Brief Description of Change
Table Name
PO_DISTRIBUTIONS_INTERFACE PDOI Add columns to support PDOI bulk processing
Processing
PO_PRICE_DIFF_INTERFACE PDOI Add columns to support PDOI bulk processing
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
Feature Area
Brief Description of Change
Table Name
various dates in lifetime of a requisition line.
none
Feature Area
View Name
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
Feature Area
View Name
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
Feature Area
View Name
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
Feature
Area Brief Description of Change
View Name
Feature
Area Brief Description of Change
View Name
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_TY
PES 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
Feature
Area Brief Description of Change
View Name
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
Feature
Area Brief Description of Change
View Name
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
Feature
Area Brief Description of Change
View Name
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
Feature
Area Brief Description of Change
View Name
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
Feature
Area Brief Description of Change
View Name
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
Feature
Area Brief Description of Change
View Name
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 Modified to return contingent
Worker workers along with the
Uptake employees, depending upon
the HR Contingent Profile is
set to Y
HR_EMPLOYEES_CURRENT_V Contingent Modified to return contingent
Feature
Area Brief Description of Change
View Name
Worker workers along with the
Uptake employees, depending upon
the HR Contingent Profile is
set to Y
PO_BUYERS_VAL_V Contingent Modified to return contingent
Worker workers along with the
Uptake employees, depending upon
the HR Contingent Profile is
set to Y
PO_BUYERS_ALL_V Contingent Modified to return contingent
Worker workers along with the
Uptake employees, depending upon
the HR Contingent Profile is
set to Y
10.Receivables
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
Table Name
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
AR_AEL_GL_REC_V Made changes to support the new Internal Bank Account data
model.
View Name Description of Change
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.
11.Payables
New Tables
Changed Tables
Obsolete Tables
Feature
Area
New Views
Changed Views
Obsolete Views
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
• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS
12. HRMS
Feature
Area
Brief Description of Change
Table Name
PER_ABSENCE_ATTENDANCE_TYPES Absences The table contains a new column called
ABSENCE_OVERLAP_FLAG.
PAY_ZA_ACB_USER_GEN_NOS South Africa The USER_CODE column data type has been
Localization changed to VARCHAR2 from NUMBER.
Hr_org_info_types_by_class Operating The enabled_flag column has been added. The
Unit Support column is mandatory, its data type is varchar2(30)
in Core HR 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 Inserted the SINGLE_BAL_TABLE rule to enable
Localization single latest balance support.
PAY_RETRO_DEFINITIONS Australia Inserted the AU_RETROPAY definition to support
Localization enhanced retro pay.
PAY_RETRO_COMPONENTS Australia Inserted row for the Backdated Changes component
Localization to support Enhanced Retro Pay.
PAY_RETRO_EFN_COMPONENTS Australia Inserted row for Backdated Changes.
Localization
Feature
Area
Brief Description of Change
Table Name
PAY_TIME_DEFINITIONS Australia Inserted rows for the following time definitions:
Localization
• START_OF_TIME
• END_OF_12_MONTHS
• START_OF_PREV_LT12
• END_OF_PREV_YEAR
• START_OF_CURRENT_YEAR
• END_OF_TIME
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.
View Name Feature Area Brief Description of Change
AU HR PERSON Australia Localization Modified to match the latest global task flow.
TASKFLOW
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.
Flexfield Name
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 Absences
(PER_ABS_CASE_DEVELOPER_DF)
Additional Absence Case Details Absences
(PER_ABSENCE_CASES)
• IN_24Q_ORG
• IN_24Q_CHALLAN
• IN_24Q_DEDUCTEE
IN_STATUTORY_INFO India A new segment called PF/EPS Contribution has been added.
Localization
Profile Options
Concurrent
Definition Name Template Name Program Brief Description of Change
PAY_IN_PT_FORM3 PYINPTX3_en_US.rtf India PT Form III The PT Form 3 report has been modified to
for Maharashtra include format changes for Statutory update
1-Apr-06.
View Data Definition XDO: Data Definition - Added field to upload data template, added buttons to
Update go to upload data template file page. Added button to
set the configuration properties at the data definition
level.
Update/Create Data XDO: Data Definition - It’s no longer possible to update/upload files on this
Definition Update 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 Can change the base translatable locale.
Information
Create Template XDO: Template General Can specify whether the template file is translatable.
Information
Add Template File XDO: Template File - Add Can specify whether the template file is translatable.
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
Views
14. TCA
Feature Area
Brief Description of Change
Table Name
Obsolete Indexes:
Customer
AR_CUSTOMER_PROFILES
Profile
AR_CUSTOMER_PROFILES_N1
HZ_CUST_ACCOUNTS Customer Obsolete Columns:
Accounts
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
CONS_BILL_LEVEL
LATE_CHARGE_CALCULATION_TRX
CREDIT_ITEMS_FLAG
Customer DISPUTED_TRANSACTIONS_FLAG
HZ_CUSTOMER_PROFILES
Profiles LATE_CHARGE_TYPE
LATE_CHARGE_TERM_ID
INTEREST_CALCULATION_PERIOD
HOLD_CHARGED_INVOICES_FLAG
MESSAGE_TEXT_ID
MULTIPLE_INTEREST_RATES_FLAG
CHARGE_BEGIN_DATE
Data Quality
HZ_DQM_STAGE_GT New column PERSON_PARTY_ID added.
Management
Geography
HZ_GEO_NAME_REFERENCE_LOG Name
Referencing Added column USAGE_CODE (VARCHAR2(30)).
Added column ADDR_VAL_LEVEL (VARCHAR2 (60)).
Geography
HZ_GEO_STRUCTURE_LEVELS Address validation level is specific to a country and value for
Hierarchy
ADDR_VAL_LEVEL should be set only at country level.
Obsolete Indexes:
HZ_LOC_ASSIGNMENTS Locations
HZ_LOC_ASSIGNMENTS_U1
Obsolete Columns:
PO_BOX_NUMBER
HOUSE_NUMBE
STREET_SUFFIX
HZ_PARTIES_N6
HZ_PARTIES_N9
PERSON_BO_VERSION
ORG_BO_VERSION
PERSON_CUST_BO_VERSION
ORG_CUST_BO_VERSION
HZ_PARTY_SITES Party Sites 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.
DQM Word
HZ_WORD_REPLACEMENTS New columns DELETE_FLAG and STAGED_FLAG.
Replacements
Salesperson in
JTF_RS_SALESREPS Resource Default value for ORG_ID has been removed.
Manager
Customer
RA_CUSTOMER_MERGE_HEADERS Added ORG_ID NUMBER column.
Merge
Customer
RA_CUSTOMER_MERGES Added ORG_ID NUMBER column.
Merge
Replaced By
Table Name Feature Area
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
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
HZ_PARAM_TAB populated HZ_PARAM_TAB table with the old and None
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.
Views
Replaced By
View Name Feature Area
HZ_CUST_ACCT_SITES Account Sites Multi-Org Synonym HZ_CUST_ACCT
HZ_CUST_SITE_USES Account Site Uses Multi-Org Synonym HZ_CUST_SITE_
HZ_CUST_ACCT_RELATE Account Relationship Multi-Org Synonym HZ_CUST_ACCT
Multi-Org Synonym
RA_CUSTOMERS_INTERFACE Customer Interface
RA_CUSTOMERS_INTERFACE
Multi-Org Synonym
RA_CUSTOMER_PROFILES_INTERFACE Customer Interface
RA_CUSTOMER_PROFILES_INTER
Multi-Org Synonym
RA_CONTACT_PHONES_INTERFACE Customer Interface
RA_CONTACT_PHONES_INTERFA
Multi-Org Synonym
RA_CUSTOMER_BANKS_INTERFACE Customer Interface
RA_CUSTOMER_BANKS_INTERFA
Multi-Org
RA_CUST_PAY_METHOD_INTERFACE Customer Interface
Synonym RA_CUST_PAY_METHOD
Backward compatible view for Accounts.
RA_HCUSTOMERS HZ_PARTIES and HZ_CUST_ACCOU
Corresponding synonym is RA_CUSTOMERS
Backward compatible view for Account Site
Uses. Corresponding synonym HZ_CUST_SITE_USES_ALL /
RA_SITE_USES_MORG
is RA_SITE_USES_ALL & HZ_CUST_SITE_USES
RA_SITE_USES.
Backward compatible view for
HZ_PARTY_SITES, HZ_LOC_ASSIG
Account Sites. Corresponding synonym
RA_ADDRESSES_MORG HZ_LOCATIONS, HZ_CUST_ACCT
is RA_ADDRESSES_ALL and
/ HZ_CUST_ACCT_SITES
RA_ADDRESSES.
Backward compatible view for Account HZ_CUST_ACCOUNT_ROLES, HZ_
RA_HCONTACTS Contacts. Corresponding synonym HZ_RELATIONSHIPS, HZ_ORG_CO
is RA_CONTACTS. HZ_CUST_ACCOUNTS
Backward compatible view for Account
Relationships. Corresponding synonym HZ_CUST_ACCT_RELATE_ALL /
RA_CUSTOMER_RELATIONSHIPS_MORG
is RA_CUSTOMER_RELATIONSHIPS_ALL HZ_CUST_ACCT_RELATE
and RA_CUSTOMER_RELATIONSHIPS.
Backward compatible view for Customer
AR_HCUSTOMER_PROFILES Profiles. Corresponding synonym HZ_CUSTOMER_PROFILES
is AR_CUSTOMER_PROFILES.
Backward compatible view for Customer
AR_HCUSTOMER_PROFILE_AMOUNTS Profile Amounts. Corresponding Synonym HZ_CUST_PROFILE_AMTS
is AR_CUSTOMER_PROFILE_AMOUNTS.
Backward compatible view for Customer
AR_HCUSTOMER_PROFILE_CLASSES Profile Classes. Corresponding synonym HZ_CUST_PROFILE_CLASSES
is AR_CUSTOMER_PROFILE_CLASSES.
Backward compatible view for Customer
Profile Class Amounts. Corresponding
AR_HCUST_PROF_CLASS_AMOUNTS HZ_CUST_PROF_CLASS_AMTS
synonym is
AR_CUST_PROF_CLASS_AMOUNTS .
Backward compatible view for Contact
RA_HCONTACT_ROLES Roles. Corresponding Synonym is HZ_ROLE_RESPONSIBILITY
RA_CONTACT_ROLES.
Backward compatible view for
HZ_CONTACT_POINTS and
RA_HPHONES Phones. Corresponding synonym is
HZ_CUST_ACCOUNT_ROLES
RA_PHONES.
HZ_PARTY_RELATIONSHIPS Backward compatible view for Relationships. HZ_RELATIONSHIPS
Backward compatible view for Contact
HZ_CONTACT_RESTRICTIONS HZ_CONTACT_PREFERENCES
Preferences.
JTF_RS_SALESREPS_MO_V Single Org view for Salesreps in Resource Multi-Org Synonym JTF_RS_SALESR
Manager.
DML
Operations
Policy Name (Select, Update,
Package Name Function Name Insert, Delete)
Synonym Name
Select, Update,
HZ_CUST_ACCT_SITES ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
HZ_CUST_SITE_USES ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
HZ_CUST_ACCT_RELATE ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
RA_CUSTOMERS_INTERFACE ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
RA_CUSTOMER_PROFILES_INTERFACE ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
RA_CONTACT_PHONES_INTERFACE ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
RA_CUSTOMER_BANKS_INTERFACE ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
RA_CUST_PAY_METHOD_INTERFACE ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete
Select, Update,
JTF_RS_SALESREPS_MO_V ORG_SEC MO_GLOBAL ORG_SECURITY
Insert, Delete