Internal Use Only Columns
The tables provided in Oracle Fusion SCM 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_CMR_DISTRIBUTIONS_CF | SUBLEDGER_LINKAGE_DST_ENTITY_ID |
| DW_CMR_EVENTS_CF | SUBLEDGER_LINKAGE_HDR_ENTITY_ID |
| DW_CMR_SLA_DISTRIBUTIONS_CF | SUBLEDGER_LINKAGE_DST_ENTITY_ID |
| DW_INV_INBOUND_DETAILS_CF | EXTRACT_TIMESTAMP |
| DW_INV_ONHAND_DETAILS_CF | EXTRACT_TIMESTAMP |
| DW_INV_RCV_SUPPLY_DETAILS_CF | EXTRACT_TIMESTAMP |
| DW_INV_RESERVATION_DETAILS_CF | EXTRACT_TIMESTAMP |
| DW_INV_AGING_CF | EXTRACT_TIMESTAMP |
| DW_CMR_DISTRIBUTIONS_ALL_CF | SUBLEDGER_LINKAGE_DST_ENTITY_ID |
| DW_CMR_EVENTS_ALL_CF | SUBLEDGER_LINKAGE_HDR_ENTITY_ID |
| DW_CMR_SLA_DISTRIBUTIONS_ALL_CF | SUBLEDGER_LINKAGE_DST_ENTITY_ID |
| DW_PURCHASE_ORDER_AGG_CF | SYSTEM_GEN_PK |
| DW_RCV_SHIPMENTS_AGG_CF | SYSTEM_GEN_PK |
| DW_REQUISITION_AGG_CF | SYSTEM_GEN_PK |
| DW_INVOICE_SPEND_AGG_CF | SYSTEM_GEN_PK |