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 |