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