Internal Use Only Columns

The tables provided in Oracle Fusion ERP Analytics include columns that are for Oracle internal use only.

The following columns aren't available for customers to use.

Table Name Target Column
All Tables SOURCE_RECORD_ID
DW_GL_LEDGER_RELATIONSHIPS_D TARGET_LEDGER_ID
DW_CHART_OF_ACC_LKP_TL CHART_OF_ACC_LKP_CODE
DW_AR_SLA_ADJUSTMENTS_CF CUSTOMER_CONTACT_ID
DW_AR_SLA_ADJUSTMENTS_CF ADJUSTMENTS_APPLIED_DATE
DW_AR_SLA_ADJUSTMENTS_CF XDL_LINE_CREATION_DATE
DW_AR_SLA_ADJUSTMENTS_CF AGING_ACCTD_DATE
DW_AR_SLA_AGING_INVOICE_CA TRANSACTION_AMOUNT
DW_AR_SLA_APPLICATIONS_CF TRANSACTION_TYPE_CODE
DW_AR_SLA_APPLICATIONS_CF XDL_LINE_CREATION_DATE
DW_AR_SLA_APPLICATIONS_CF AGING_ACCTD_DATE
DW_AR_SLA_CREDITMEMO_CF XDL_LINE_CREATION_DATE
DW_AR_SLA_CREDITMEMO_CF AGING_ACCTD_DATE
DW_AR_SLA_REVENUE_CF XDL_LINE_CREATION_DATE
DW_AR_SLA_SCHEDULES_CF ACCOUNTING_DATE
DW_AR_SLA_SCHEDULES_CF SCHEDULE_ACTUAL_CLOSED_DATE
DW_AR_SLA_SCHEDULES_CF XDL_LINE_CREATION_DATE
DW_AR_SLA_SCHEDULES_CF AGING_ACCTD_DATE
DW_AR_SLA_TRANSACTIONS_CF ACCOUNTING_DATE
DW_AR_SLA_TRANSACTIONS_CF XDL_LINE_CREATION_DATE
DW_AR_AGING_ACCNTD_INVOICE_CA TRANSACTION_AMOUNT
DW_AR_ACC_UNACC_SCHEDULES_CF SCHEDULE_ACTUAL_CLOSED_DATE
DW_VRM_FMV_TEMPLATES_D FMV_PRICE_TYPE
DW_VRM_FMV_TEMPLATES_D USE_TOLERANCE_FOR_COMPLIANCE
DW_VRM_PRICING_COMBINATIONS_D SUMMARY_FLAG
DW_VRM_FMV_LINES_DATA_SET_USAGES_CF PRICE_BASIS_DATA_SET_ID
DW_AP_SLA_INVOICE_SCHEDULE_CF PRE_POST_SLA_FLAG
DW_AP_SLA_AGING_INV_CA PRE_POST_SLA_FLAG
DW_AP_SLA_AGING_INVOICE_CA PRE_POST_SLA_FLAG
DW_AP_SLA_AGING_SUPPLIER_CA PRE_POST_SLA_FLAG
DW_AR_SLA_SCHEDULES_CF PRE_POST_SLA_FLAG
DW_AR_SLA_AGING_INVOICE_CA PRE_POST_SLA_FLAG
DW_AR_SLA_AGING_CUSTOMER_CA PRE_POST_SLA_FLAG
DW_PROJECT_COST_AGG_CF SYSTEM_GEN_PK
DW_PROJECT_SLA_COST_AGG_CF SYSTEM_GEN_PK