Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
5
AI Foundation Data Standalone Process Flows
Standalone processes are separated across several different flows within POM depending on the order in which you need to execute them and the dependencies to be followed. This chapter provides a tabular view of related jobs across the different process flows in the AIF DATA schedule so that you know which jobs are safe to enable or disable, depending on the files you’re attempting to load into the platform. It is always a best practice to disable jobs in POM if you are not actively using them, both to reduce runtimes and to avoid loading data you did not intend to process.
Process Flows for DAT Files
The table below shows the standalone process flows for any file with a .dat extension. Please note that the following list of jobs should remain enabled and are usually applicable to all batch runs, so they’re not included in the table.
-
VARIABLE_REFRESH_JOB
-
ETL_REFRESH_RI_JOB
-
ETL_BUSINESS_DATE_JOB
-
W_RTL_CURR_MCAL_G_JOB
-
RI_UPDATE_TENANT_JOB (as part of HIST_ZIP_FILE_LOAD_ADHOC)
Table 5-1 DAT File Process Flows
| Input Files (DAT) | DAT_REPROCESS_ADHOC | RI_DIM_INITIAL_ADHOC |
|---|---|---|
| W_CODE_DS.dat | W_CODE_DS_COPY_JO W_CODE_DS_STG_JOB | W_CODE_D_JOB |
| W_DOMAIN_MEMBER_DS_T L.dat | W_DOMAIN_MEMBER_DS_TL_CO PY_JOB W_DOMAIN_MEMBER_DS_TL_ST G_JOB | W_DOMAIN_MEMBER_LKP_TL _JOB |
| W_EMPLOYEE_DS.dat | W_EMPLOYEE_DS_COPY_JOB W_EMPLOYEE_DS_STG_JOB | W_EMPLOYEE_D_JOB |
| W_EXCH_RATE_GS.dat | W_EXCH_RATE_GS_COPY_JOB W_EXCH_RATE_GS_STG_JOB | W_EXCH_RATE_G_JOB |
| W_HOUSEHOLD_DS.dat | W_HOUSEHOLD_DS_COPY_JOB W_HOUSEHOLD_DS_STG_JOB | W_HOUSEHOLD_D_JOB |
| W_INT_ORG_ATTR_DS.dat | W_INT_ORG_ATTR_DS_COPY_JOB | W_INT_ORG_D_TYPE1_JOB |
| W_INT_ORG_DS.dat W_INT_ORG_DS_TL.dat | W_INT_ORG_ATTR_DS_STG_JOB W_INT_ORG_DS_COPY_JOB W_INT_ORG_DS_STG_JOB W_INT_ORG_DS_TL_COPY_JOB W_INT_ORG_DS_TL_STG_JOB | W_RTL_ORG_RECLASS_TMP_JO B |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
| Input Files (DAT) | DAT_REPROCESS_ADHOC | RI_DIM_INITIAL_ADHOC |
|---|---|---|
| W_INT_ORG_DS_CFA.dat | W_INT_ORG_DS_CFA_COPY_JOB W_INT_ORG_DS_CFA_STG_JOB | W_INT_ORG_D_CFA_JOB |
| W_INT_ORG_DHS.dat | W_INT_ORG_DHS_COPY_JOB W_INT_ORG_DHS_STG_JOB | W_INT_ORG_DH_TYPE1_JOB W_INT_ORG_DH_RTL_TMP_JOB |
| W_PARTY_ATTR_DS.dat | W_PARTY_ATTR_DS_COPY_JOB W_PARTY_ATTR_DS_STG_JOB | W_PARTY_ATTR_D_JOB |
| W_PARTY_ORG_DS.dat | W_PARTY_ORG_DS_COPY_JOB W_PARTY_ORG_DS_STG_JOB | W_PARTY_ORG_D_JOB |
| W_PARTY_ORG_DS_CFA.dat | W_PARTY_ORG_DS_CFA_COPY_JO B W_PARTY_ORG_DS_CFA_STG_JOB | W_PARTY_ORG_D_CFA_JOB |
| W_PARTY_PER_DS.dat | W_PARTY_PER_DS_COPY_JOB W_PARTY_PER_DS_STG_JOB | W_PARTY_PER_D_JOB |
| W_PROD_CAT_DHS.dat | W_PROD_CAT_DHS_COPY_JOB W_PROD_CAT_DHS_STG_JOB | W_PROD_CAT_DH_TYPE1_JOB W_PROD_CAT_DH_SC_RTL_TM P_JOB |
| W_PROD_CAT_DHS_CFA.dat | W_PROD_CAT_DHS_CFA_COPY_JO B W_PROD_CAT_DHS_CFA_STG_JOB | W_PROD_CAT_DH_CFA_JOB |
| W_PRODUCT_ATTR_DS.dat | W_PRODUCT_ATTR_DS_COPY_JOB W_PRODUCT_ATTR_DS_STG_JOB | W_PRODUCT_ATTR_D_JOB W_RTL_PRODUCT_ATTR_UDA_ D_JOB |
| W_PRODUCT_DS.dat | W_PRODUCT_DS_COPY_JOB | W_PRODUCT_D_TYPE1_JOB |
| W_PRODUCT_DS_TL.dat | W_PRODUCT_DS_STG_JOB W_PRODUCT_DS_TL_COPY_JOB W_PRODUCT_DS_TL_STG_JOB | W_RTL_PROD_RECLASS_TMP_I NITIAL_JOB W_PRODUCT_D_RTL_TMP_JOB W_RTL_PROD_RECLASS_TMP_J OB W_RTL_PRODUCT_AGGR_D_JO B |
| W_PRODUCT_DS_CFA.dat | W_PRODUCT_DS_CFA_COPY_JOB W_PRODUCT_DS_CFA_STG_JOB | W_PRODUCT_D_CFA_JOB |
| W_REASON_DS.dat | W_REASON_DS_COPY_JOB W_REASON_DS_STG_JOB | W_REASON_D_JOB |
| W_RTL_ALC_DETAILS_DS.da t | W_RTL_ALC_DETAILS_DS_COPY_J OB W_RTL_ALC_DETAILS_DS_STG_JO B | W_RTL_ALC_DETAILS_D_JOB |
| W_RTL_ALLOC_CHRG_DETA ILS_DS.dat | W_RTL_ALLOC_CHRG_DETAILS_D S_COPY_JOB W_RTL_ALLOC_CHRG_DETAILS_D S_STG_JOB | W_RTL_ALLOC_CHRG_DETAILS _D_JOB |
| W_RTL_BUYER_DS.dat | W_RTL_BUYER_DS_COPY_JOB W_RTL_BUYER_DS_STG_JOB | W_RTL_BUYER_D_JOB |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
| Input Files (DAT) | DAT_REPROCESS_ADHOC | RI_DIM_INITIAL_ADHOC |
|---|---|---|
| W_RTL_CHANNEL_DS.dat | W_RTL_CHANNEL_DS_COPY_JOB W_RTL_CHANNEL_DS_STG_JOB | W_RTL_CHANNEL_D_JOB |
| W_RTL_CLSTR_GRP_DS.dat | W_RTL_CLSTR_GRP_DS_COPY_JOB W_RTL_CLSTR_GRP_DS_STG_JOB | W_RTL_CLSTR_GRP_D_JOB |
| W_RTL_CLSTR_HDR_DS.dat | W_RTL_CLSTR_HDR_DS_COPY_JO B W_RTL_CLSTR_HDR_DS_STG_JOB W_DOMAIN_MEMBER_DS_TL_OR ASE_JOB | W_RTL_CLSTR_HDR_D_JOB W_DOMAIN_MEMBER_LKP_TL _JOB |
| W_RTL_CLSTR_GRP_HDR_LC _DS.dat | W_RTL_CLSTR_GRP_HDR_LC_DS_ COPY_JOB W_RTL_CLSTR_GRP_HDR_LC_DS_ STG_JOB | W_RTL_CLSTR_GRP_HDR_LC_D _JOB |
| W_RTL_CLSTR_GRP_PRD_DS. dat | W_RTL_CLSTR_GRP_PRD_DS_COP Y_JOB W_RTL_CLSTR_GRP_PRD_DS_STG_ JOB | W_RTL_CLSTR_GRP_IT_D_JOB |
| W_RTL_CMG_PRODUCT_MT X_DS.dat | W_RTL_CMG_PRODUCT_MTX_DS_ COPY_JOB W_RTL_CMG_PRODUCT_MTX_DS_ STG_JOB | W_RTL_CMG_PRODUCT_MTX_ D_JOB |
| W_RTL_CO_HEAD_DS.dat | W_RTL_CO_HEAD_DS_COPY_JOB W_RTL_CO_HEAD_DS_STG_JOB | W_RTL_CO_HEAD_D_JOB |
| W_RTL_CO_LINE_DS.dat | W_RTL_CO_LINE_DS_COPY_JOB W_RTL_CO_LINE_DS_STG_JOB | W_RTL_CO_LINE_D_JOB |
| W_RTL_CO_SHIP_METHOD_ DS.dat | W_RTL_CO_SHIP_METHOD_DS_C OPY_JOB W_RTL_CO_SHIP_METHOD_DS_ST G_JOB | W_RTL_CO_SHIP_METHOD_D_J OB |
| W_RTL_CO_SHIP_TYPE_DS.d at | W_RTL_CO_SHIP_TYPE_DS_COPY_ JOB W_RTL_CO_SHIP_TYPE_DS_STG_J OB | W_RTL_CO_SHIP_TYPE_D_JOB |
| W_RTL_CODE_DS.dat | W_RTL_CODE_DS_COPY_JOB W_RTL_CODE_DS_STG_JOB | W_RTL_CODE_D_JOB |
| W_RTL_COMP_STORE_DS.da t | W_RTL_COMP_STORE_DS_COPY_J OB W_RTL_COMP_STORE_DS_STG_JO B | W_RTL_COMP_STORE_D_JOB |
| W_RTL_COUPON_DS.dat W_RTL_COUPON_DS_TL.dat | W_RTL_COUPON_DS_COPY_JOB W_RTL_COUPON_DS_STG_JOB W_RTL_COUPON_DS_TL_COPY_JO B W_RTL_COUPON_DS_TL_STG_JOB | W_RTL_COUPON_D_JOB |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
Input Files (DAT) DAT_REPROCESS_ADHOC RI_DIM_INITIAL_ADHOC W_RTL_CUST_ADDRESS_DS. W_RTL_CUST_ADDRESS_DS_COPY W_RTL_CUST_ADDRESS_D_JOB dat JOB W_RTL_CUST_ADDRESS_DS_STG_J OB W_RTL_CUST_CUSTSEG_DS.d W_RTL_CUST_CUSTSEG_DS_COPY W_RTL_CUST_CUSTSEG_D_JOB at JOB W_RTL_CUST_CUSTSEG_DS_STG_J OB W_RTL_CUST_DEDUP_DS.dat W_RTL_CUST_DEDUP_DS_COPY_J W_PARTY_PER_D_JOB (data OB used implicitly during dim load) W_RTL_CUST_DEDUP_DS_STG_JO B W_RTL_CUST_HOUSEHOLD W_RTL_CUST_HOUSEHOLD_DS_C W_RTL_CUST_HOUSEHOLD_D DS.dat OPY_JOB JOB W_RTL_CUST_HOUSEHOLD_DS_S TG_JOB W_RTL_CUSTSEG_ALLOC_DS W_RTL_CUSTSEG_ALLOC_DS_COP W_RTL_CUSTSEG_ALLOC_D_JO .dat Y_JOB B W_RTL_CUSTSEG_ALLOC_DS_STG _JOB W_RTL_CUSTSEG_ATTR_DS. W_RTL_CUSTSEG_ATTR_DS_COPY W_RTL_CUSTSEG_D_JOB (data dat JOB used implicitly during dim load) W_RTL_CUSTSEG_ATTR_DS_STG_J OB W_RTL_DEAL_DS.dat W_RTL_DEAL_DS_COPY_JOB W_RTL_DEAL_D_JOB W_RTL_DEAL_DS_STG_JOB W_RTL_DEPT_CHRG_DETAIL W_RTL_DEPT_CHRG_DETAILS_DS W_RTL_DEPT_CHRG_DETAILS S_DS.dat _COPY_JOB D_JOB W_RTL_DEPT_CHRG_DETAILS_DS _STG_JOB W_RTL_DIFF_GRP_DS.dat W_RTL_DIFF_GRP_DS_COPY_JOB W_RTL_DIFF_GRP_D_JOB W_RTL_DIFF_GRP_DS_TL.dat W_RTL_DIFF_GRP_DS_STG_JOB W_RTL_DIFF_GRP_DS_TL_COPY_J OB W_RTL_DIFF_GRP_DS_TL_STG_JO B W_RTL_DIFF_RNG_DS.dat W_RTL_DIFF_RNG_DS_COPY_JOB W_RTL_DIFF_RNG_D_JOB W_RTL_DIFF_RNG_DS_TL.da W_RTL_DIFF_RNG_DS_STG_JOB W_RTL_DIFF_RNG_D_JOB t W_RTL_DIFF_RNG_DS_TL_COPY_J OB W_RTL_DIFF_RNG_DS_TL_STG_JO B W_RTL_DISCOUNT_TYPE_DS W_RTL_DISCOUNT_TYPE_DS_COP W_RTL_DISCOUNT_TYPE_D_JO .dat Y_JOB B W_RTL_DISCOUNT_TYPE_DS_STG _JOB
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
Input Files (DAT) DAT_REPROCESS_ADHOC RI_DIM_INITIAL_ADHOC W_RTL_ELC_COMP_DS.dat W_RTL_ELC_COMP_DS_COPY_JOB W_RTL_ELC_COMP_D_JOB W_RTL_ELC_COMP_DS_STG_JOB W_RTL_HOUSEHOLD_COMP W_RTL_HOUSEHOLD_COMP_DS_ W_RTL_HOUSEHOLD_COMP_D DS.dat COPY_JOB JOB W_RTL_HOUSEHOLD_COMP_DS_S TG_JOB W_RTL_HOUSEHOLD_GRP W_RTL_HOUSEHOLD_GRP_DS_CO W_RTL_HOUSEHOLD_GRP_D_J DS.dat PY_JOB OB W_RTL_HOUSEHOLD_GRP_DS_ST G_JOB W_RTL_IT_LC_DS_CFA.dat W_RTL_IT_LC_DS_CFA_COPY_JOB W_RTL_IT_LC_D_CFA_JOB W_RTL_IT_LC_DS_CFA_STG_JOB W_RTL_IT_SUPPLIER_DS.dat W_RTL_IT_SUPPLIER_DS_COPY_J W_RTL_IT_SUPPLIER_D_JOB OB W_RTL_IT_SUPPLIER_DS_STG_JOB W_RTL_ITEM_CHRG_DETAIL W_RTL_ITEM_CHRG_DETAILS_DS W_RTL_ITEM_CHRG_DETAILS S_DS.dat _COPY_JOB D_JOB W_RTL_ITEM_CHRG_DETAILS_DS _STG_JOB W_RTL_ITEM_GRP1_DS.dat W_RTL_ITEM_GRP1_DS_COPY_JO W_RTL_ITEM_GRP1_D_ITEMBR B AND_JOB W_RTL_ITEM_GRP1_DS_STG_JOB W_RTL_ITEM_GRP1_D_ITEMCO LOR_JOB W_RTL_ITEM_GRP1_D_ITEMDI FF_JOB W_RTL_ITEM_GRP1_D_ITEMFA B_JOB W_RTL_ITEM_GRP1_D_ITEMLI ST_JOB W_RTL_ITEM_GRP1_D_ITEMLV JOB W_RTL_ITEM_GRP1_D_ITEMSC EN_JOB W_RTL_ITEM_GRP1_D_ITEMSI ZE_JOB W_RTL_ITEM_GRP1_D_ITEMST YLE_JOB W_RTL_ITEM_GRP1_D_ITEMUD A_JOB W_RTL_PRODUCT_ATTR_UDA D_JOB
W_RTL_ITEM_GRP3_DS.dat W_RTL_ITEM_GRP3_DS_COPY_JO W_RTL_ITEM_GRP3_D_JOB B W_RTL_ITEM_GRP3_DS_STG_JOB W_RTL_LOC_LIST_DS.dat W_RTL_LOC_LIST_DS_COPY_JOB W_RTL_LOC_LIST_D_JOB W_RTL_LOC_LIST_DS_STG_JOB
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
| Input Files (DAT) | DAT_REPROCESS_ADHOC | RI_DIM_INITIAL_ADHOC |
|---|---|---|
| W_RTL_LOC_TRAIT_DS.dat | W_RTL_LOC_TRAIT_DS_COPY_JOB W_RTL_LOC_TRAIT_DS_STG_JOB | W_RTL_LOC_TRAIT_D_JOB |
| W_RTL_LOC_TRAIT_DS_TL.d at | W_RTL_LOC_TRAITS_DS_TL_COPY JOB W_RTL_LOC_TRAITS_DS_TL_STG JOB | W_RTL_LOC_TRAIT_D_JOB |
| W_RTL_LOC_STOCK_CNT_DS .dat | W_RTL_LOC_STOCK_CNT_DS_COP Y_JOB W_RTL_LOC_STOCK_CNT_DS_STG _JOB | W_RTL_LOC_STOCK_CNT_D_JO B |
| W_RTL_MCAL_DAY_DS_CFA. dat | W_RTL_MCAL_DAY_DS_CFA_COPY _JOB W_RTL_MCAL_DAY_DS_CFA_STG_J OB | W_RTL_MCAL_DAY_D_CFA_JOB |
| W_RTL_NON_MERCH_CODE _DS.dat | W_RTL_NON_MERCH_CODE_DS_C OPY_JOB W_RTL_NON_MERCH_CODE_DS_S TG_JOB | W_RTL_NON_MERCH_CODE_D_ JOB |
| W_RTL_ORG_FIN_DS.dat | W_RTL_ORG_FIN_DS_COPY_JOB W_RTL_ORG_FIN_DS_STG_JOB | W_RTL_ORG_FIN_D_JOB |
| W_RTL_PARTY_PER_ATTR_D S.dat | W_RTL_PARTY_PER_ATTR_DS_CO PY_JOB W_RTL_PARTY_PER_ATTR_DS_ST G_JOB | W_PARTY_ATTR_D_UDA_JOB |
| W_RTL_PHASE_DS.dat | W_RTL_PHASE_DS_COPY_JOB W_RTL_PHASE_DS_STG_JOB | W_RTL_PHASE_D_JOB |
| W_RTL_PO_DETAILS_DS.dat | W_RTL_PO_DETAILS_DS_COPY_JO B W_RTL_PO_DETAILS_DS_STG_JOB | W_RTL_PO_DETAILS_D_JOB |
| W_RTL_PO_DETAILS_DS_CF A.dat | W_RTL_PO_DETAILS_DS_CFA_COP Y_JOB W_RTL_PO_DETAILS_DS_CFA_STG _JOB | W_RTL_PO_DETAILS_D_CFA_JO B |
| W_RTL_PO_DETAILS_IT_LC_ DS_CFA.dat | W_RTL_PO_DETAILS_IT_LC_DS_C FA_COPY_JOB W_RTL_PO_DETAILS_ IT_LC_DS_CFA_STG_JOB | W_RTL_PO_DETAILS_ IT_LC_D_CFA_JOB |
| W_RTL_PRICE_CLR_IT_LC_D S.dat | W_RTL_PRICE_CLR_IT_LC_DS_CO PY_JOB W_RTL_PRICE_CLR_IT_LC_DS_STG _JOB | W_RTL_PRICE_CLR_IT_LC_D_JO B |
| W_RTL_PROD_HIER_ATTR_L KP_DHS.dat | W_RTL_PROD_HIER_ATTR_LKP_D HS_COPY_JOB | W_RTL_PROD_HIER_ATTR_LKP _DH_JOB |
| W_RTL_PROD_HIER_ATTR_LKP_D HS_STG_JOB | W_RTL_PROD_HIER_ATTR_LKP _DH_IM_JOB |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
Input Files (DAT) DAT_REPROCESS_ADHOC RI_DIM_INITIAL_ADHOC W_RTL_PROD_HIER_IMAGE_ W_RTL_PROD_HIER_IMAGE_DS_C W_RTL_PROD_HIER_ATTR_LKP DS.dat OPY_JOB DH_IM_JOB W_RTL_PROD_HIER_IMAGE_DS_S TG_JOB W_RTL_PRODUCT_ATTR_DS. W_RTL_PRODUCT_ATTR_DS_COPY W_RTL_PRODUCT_ATTR_D_JOB dat JOB W_RTL_PRODUCT_ATTR_DS_STG JOB W_RTL_PRODUCT_ATTR_DS W_RTL_PRODUCT_ATTR_DS_TL_C W_RTL_PRODUCT_ATTR_D_JOB TL.dat OPY_JOB W_RTL_PRODUCT_ATTR_DS_TL_S TG_JOB W_RTL_PRODUCT_ATTR_IM W_RTL_PRODUCT_ATTR_IMG_DS_ W_RTL_PRODUCT_ATTR_IMG_ G_DS.dat COPY_JOB D_JOB W_RTL_PRODUCT_ATTR_IMG_DS_ STG_JOB W_RTL_PRODUCT_BRAND_D W_RTL_PRODUCT_BRAND_DS_CO W_RTL_PRODUCT_BRAND_D_J S.dat PY_JOB OB W_RTL_PRODUCT_BRAND_D W_RTL_PRODUCT_BRAND_DS_ST S_TL.dat G_JOB W_RTL_PRODUCT_BRAND_DS_TL _COPY_JOB W_RTL_PRODUCT_BRAND_DS_TL _STG_JOB W_RTL_PRODUCT_IMAGE_D W_RTL_PRODUCT_IMAGE_DS_CO W_PRODUCT_ATTR_D_JOB S.dat PY_JOB (data used implicitly by dim load) W_RTL_PRODUCT_IMAGE_DS_ST G_JOB W_RTL_PROMO_DS.dat W_RTL_PROMO_DS_COPY_JOB W_RTL_PROMO_D_TL_JOB W_RTL_PROMO_DS_TL.dat W_RTL_PROMO_DS_STG_JOB W_PROMO_D_RTL_TMP_JOB W_RTL_PROMO_CE_DS.dat W_RTL_PROMO_CE_DS_COPY_JOB W_RTL_PROMO_D_TL_JOB W_RTL_PROMO_CE_DS_STG_JOB W_PROMO_D_RTL_TMP_JOB W_RTL_PROMO_CE_IT_LC_D W_RTL_PROMO_CE_IT_LC_DS_CO W_RTL_PROMO_IT_LC_D_JOB S.dat PY_JOB W_RTL_PROMO_CE_IT_LC_DS_ST G_JOB W_RTL_PROMO_EXT_DS.dat W_RTL_PROMO_EXT_DS_COPY_JO W_RTL_PROMO_D_TL_JOB B W_PROMO_D_RTL_TMP_JOB W_RTL_PROMO_EXT_DS_STG_JOB W_RTL_PROMO_IT_LC_DS.d W_RTL_PROMO_IT_LC_DS_COPY_J W_RTL_PROMO_IT_LC_D_JOB at OB W_RTL_PROMO_IT_LC_DS_STG_JO B W_RTL_REPL_DAY_DS.dat W_RTL_REPL_DAY_DS_COPY_JOB W_RTL_REPL_DAY_D_JOB W_RTL_REPL_DAY_DS_STG_JOB W_RTL_SEASON_DS.dat W_RTL_SEASON_DS_COPY_JOB W_RTL_SEASON_D_JOB W_RTL_SEASON_DS_STG_JOB
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-1 (Cont.) DAT File Process Flows
| Input Files (DAT) | DAT_REPROCESS_ADHOC | RI_DIM_INITIAL_ADHOC |
|---|---|---|
| W_RTL_SEASON_PHASE_IT_ DS.dat | W_RTL_SEASON_PHASE_IT_DS_C OPY_JOB W_RTL_SEASON_PHASE_IT_DS_ST G_JOB | W_RTL_SEASON_PHASE_IT_D_J OB |
| W_RTL_SUB_IT_LC_DS.dat | W_RTL_SUB_IT_LC_DS_COPY_JOB W_RTL_SUB_IT_LC_DS_STG_JOB | W_RTL_SUB_IT_LC_D_JOB |
| W_RTL_SUPPLIER_TRAIT_DS .dat | W_RTL_SUPPLIER_TRAIT_DS_COP Y_JOB W_RTL_SUPPLIER_TRAIT_DS_STG _JOB | W_RTL_SUPPLIER_TRAIT_D_JO B |
| W_RTL_TRADE_AREA_DS.da t | W_RTL_TRADE_AREA_DS_COPY_J OB W_RTL_TRADE_AREA_DS_STG_JO B | W_RTL_TRADE_AREA_D_JOB |
| W_RTL_TRADE_AREA_LOC_ MTX_DS.dat | W_RTL_TRADE_AREA_LOC_MTX_ DS_COPY_JOB W_RTL_TRADE_AREA_LOC_MTX_ DS_STG_JOB | W_RTL_TRADE_AREA_LOC_MT X_D_JOB |
| W_RTL_TNDR_TYPE_DS.dat | W_RTL_TNDR_TYPE_DS_COPY_JO B W_RTL_TNDR_TYPE_DS_STG_JOB | W_RTL_TNDR_TYPE_D_JOB |
| W_RTL_TSF_CHRG_DETAILS _DS.dat | W_RTL_TSF_CHRG_DETAILS_DS_C OPY_JOB W_RTL_TSF_CHRG_DETAILS_DS_S TG_JOB | W_RTL_TSF_CHRG_DETAILS_D _JOB |
| W_RTL_TSF_DETAILS_DS.dat | W_RTL_TSF_DETAILS_DS_ COPY_JOB W_RTL_TSF_DETAILS_DS_ STG_JOB | W_RTL_TSF_DETAILS_D_JOB |
| W_RTL_TSF_DETAILS_DS_CF A.dat | W_RTL_TSF_DETAILS_DS_CFA_CO PY_JOB W_RTL_TSF_DETAILS_DS_CFA_ST G_JOB | W_RTL_TSF_DETAILS_D_CFA_J OB |
| W_STATUS_DS.dat | W_STATUS_DS_COPY_JOB W_STATUS_DS_STG_JOB | W_STATUS_D_JOB |
| W_RTL_UDA_METADATA_G. dat | W_RTL_UDA_METADATA_G_COPY _JOB W_RTL_UDA_METADATA_G_STG_J OB | N/A – No additional job required |
Process Flows for CSV Files
The table below shows the standalone process flows for any dimension file with a .csv extension. CSV files follow a different load path as they are simplified interfaces that are transformed from one input file to many output tables in the data model. The same set of jobs are also present in the Nightly batch cycles, so you can use this section as a reference for nightly batch configuration (ignoring the standalone process names). Please note that the
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
following list of jobs should remain enabled and are usually applicable to all batch runs, so they’re not included in the table.
-
RI_UPDATE_TENANT_JOB (as part of HIST_ZIP_FILE_LOAD_ADHOC)
-
VARIABLE_REFRESH_JOB
-
ETL_REFRESH_RI_JOB
-
ETL_BUSINESS_DATE_JOB
-
W_RTL_CURR_MCAL_G_JOB
-
SI_W_DOMAIN_MEMBER_DS_TL_TRUNC_JOB
The W_DOMAIN_MEMBER_DS_TL table works differently from other loaders, as multiple jobs are inserting into the same staging area for different sets of records. The job above is needed at the start of a process flow to truncate the W_DOMAIN_MEMBER_DS_TL table before inserting new records in all later steps in RI_DIM_INITIAL_ADHOC . If you are loading files one at a time, make sure you do not truncate W_DOMAIN_MEMBER_DS_TL excessively. It is only needed at the beginning of a new set of file loads or when starting over after an initial load was done.
Another important note is that you will want to load files in a certain order or together as sets, depending on the data you have available. If possible, you should load all your files as a set, once they become available, rather than reloading one by one every time.
Table 5-2 CSV File Process Flows
| Input Files (CSV) | RI_DIM_INITIAL_ADH OC (Step 1) | RI_DIM_INITIAL_ADHOC (Step 2) | RI_DIM_INITIAL_ADHOC (Step 3) |
|---|---|---|---|
| ATTR.csv PROD_ATTR.csv | COPY_SI_ATTR_JOB STG_SI_ATTR_JOB COPY_SI_PROD_ATTR_ JOB STG_SI_PROD_ATTR_J OB | SI_W_RTL_PRODUCT_ATT R_DS_JOB SI_W_RTL_PRODUCT_ATT R_DS_TL_JOB SI_W_RTL_ITEM_GRP1_DS _JOB STAGING_SI_W_RTL_PROD ATTR_ITEM_GRP1_DS_JOB | W_RTL_PRODUCT_ATTR_D _JOB W_RTL_ITEM_GRP1_D_ITE MBRAND_JOB W_RTL_ITEM_GRP1_D_ITE MCOLOR_JOB W_RTL_ITEM_GRP1_D_ITE MDIFF_JOB |
| SI_ATTR_W_DOMAIN_ME MBER_DS_TL_JOB SI_PROD_ATTR_W_DOMAI N_MEMBER_DS_TL_JOB | W_RTL_ITEM_GRP1_D_ITE MFAB_JOB W_RTL_ITEM_GRP1_D_ITE MLIST_JOB | ||
| SI_W_RTL_PRODUCT_COL OR_DS_JOB | W_RTL_ITEM_GRP1_D_ITE MLV_JOB | ||
| W_RTL_ITEM_GRP1_D_ITE MSCEN_JOB | |||
| W_RTL_ITEM_GRP1_D_ITE MSIZE_JOB | |||
| W_RTL_ITEM_GRP1_D_ITE MSTYLE_JOB W_RTL_ITEM_GRP1_D_ITE MUDA_JOB | |||
| W_DOMAIN_MEMBER_LK P_TL_JOB W_RTL_PRODUCT_ATTR_U DA_D_JOB |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-2 (Cont.) CSV File Process Flows
Input Files RI_DIM_INITIAL_ADH RI_DIM_INITIAL_ADHOC RI_DIM_INITIAL_ADHOC (CSV) OC (Step 1) (Step 2) (Step 3) CODES.csv COPY_SI_CODES_JOB STAGING_SI_W_RTL_CODE W_RTL_CODE_D_JOB STG_SI_CODES_JOB DS_JOB DIFF_GROUP.csv COPY_SI_DIFF_GROUP SI_W_RTL_DIFF_GRP_DS_J W_RTL_DIFF_GRP_D_JOB JOB OB STG_SI_DIFF_GROUP_J SI_W_RTL_DIFF_GRP_DS_T OB L_JOB EMPLOYEE.csv COPY_SI_EMPLOYEE_J SI_W_EMPLOYEE_DS_JOB W_EMPLOYEE_D_JOB OB STG_SI_EMPLOYEE_JO B EXCH_RATE.csv COPY_SI_EXCH_RATE SI_W_EXCH_RATE_GS_JOB W_EXCH_RATE_G_JOB JOB STG_SI_EXCH_RATE_J OB ORGANIZATION. COPY_SI_ORGANIZATI SI_W_INT_ORG_DHS_JOB W_INT_ORG_DH_TYPE1_JO csv ON_JOB B SI_W_INT_ORG_ATTR_DS_J STG_SI_ORGANIZATIO OB W_INT_ORG_D_TYPE1_JOB N_JOB SI_W_INT_ORG_DS_JOB W_INT_ORG_DH_RTL_TMP SI_W_INT_ORG_DS_TL_JO JOB B W_RTL_CHANNEL_D_JOB SI_W_RTL_CHANNEL_DS_J W_RTL_CHANNEL_CNTRY OB D_JOB SI_ORG_W_DOMAIN_MEM W_DOMAIN_MEMBER_LK BER_DS_TL_JOB P_TL_JOB SI_W_RTL_CHANNEL_CNT RY_DS_JOB DIM_ORG_VALIDATOR_JO B ORGANIZATION COPY_SI_ORGANIZATI SI_W_ORGANIZATION_FL W_ORGANIZATION_FLEX ALT.csv ON_ALT_JOB EX_DS_JOB D_JOB STG_SI_ORGANIZATIO N_ALT_JOB PROD_LOC_ATT COPY_SI_PROD_LOC_A SI_W_RTL_IT_LC_DS_JOB W_RTL_IT_LC_D_JOB R.csv TTR_JOB STG_SI_PROD_LOC_AT TR_JOB PROD_LOC_REP COPY_SI_PROD_LOC_R STAGING_SI_W_INVENTO W_INVENTORY_PRODUCT L.csv EPL_JOB RY_PRODUCT_ATTR_DS_JO D_JOB STG_SI_PROD_LOC_RE B PL_JOB PROD_PACK.csv COPY_SI_PROD_PACK_ STAGING_SI_W_RTL_ITEM W_RTL_ITEM_GRP2_D_JOB JOB _GRP2_DS_JOB STG_SI_PROD_PACK_J OB
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-2 (Cont.) CSV File Process Flows
Input Files RI_DIM_INITIAL_ADH RI_DIM_INITIAL_ADHOC RI_DIM_INITIAL_ADHOC (CSV) OC (Step 1) (Step 2) (Step 3) PROD_SEASON.c COPY_SI_SEASON_JOB STAGING_SI_W_RTL_PHAS W_RTL_SEASON_D_JOB sv STG_SI_SEASON_JOB E_DS_JOB W_RTL_PHASE_D_JOB SEASON.csv COPY_SI_PROD_SEASO STAGING_SI_W_RTL_SEAS W_RTL_SEASON_PHASE_I N_JOB ON_DS_JOB T_D_JOB STG_SI_PROD_SEASON STAGING_SI_W_RTL_SEAS W_DOMAIN_MEMBER_LK JOB ON_PHASE_IT_DS_JOB P_TL_JOB SI_SEASON_W_DOMAIN MEMBER_DS_TL_JOB PRODUCT.csv COPY_SI_PRODUCT_JO SI_W_PROD_CAT_DHS_JOB W_PROD_CAT_DH_TYPE1_J B SI_W_PRODUCT_ATTR_DS_ OB STG_SI_PRODUCT_JOB JOB W_RTL_PROD_HIER_ATTR SI_W_PRODUCT_DS_JOB _LKP_DH_JOB SI_W_PRODUCT_DS_TL_JO W_PROD_CAT_DH_SC_RTL B _TMP_JOB SI_W_RTL_IT_SUPPLIER_D W_RTL_PROD_HIER_ATTR S_JOB LKP_DH_IM_JOB SI_W_RTL_PRODUCT_ATT W_PRODUCT_D_TYPE1_JO R_IMG_DS_JOB B SI_W_RTL_PRODUCT_BRA W_PRODUCT_ATTR_D_JOB ND_DS_JOB W_PRODUCT_D_RTL_TMP SI_W_RTL_PRODUCT_BRA JOB ND_DS_TL_JOB W_RTL_IT_SUPPLIER_D_JO SI_PROD_W_DOMAIN_ME B MBER_DS_TL_JOB W_RTL_PRODUCT_BRAND DIM_PROD_VALIDATOR_J D_JOB OB W_DOMAIN_MEMBER_LK P_TL_JOB W_RTL_PRODUCT_ATTR_U DA_D_JOB PRODUCT_ALT.cs COPY_SI_PRODUCT_A SI_W_PRODUCT_FLEX_DS W_PRODUCT_FLEX_D_JOB v LT_JOB JOB STG_SI_PRODUCT_ALT JOB PROMOTION.csv COPY_SI_PROMO_EXT SI_W_RTL_PROMO_EXT_D W_RTL_PROMO_D_TL_JOB JOB S_JOB W_PROMO_D_RTL_TMP_JO STG_SI_PROMO_EXT_J B OB PROMO_DETAIL. COPY_SI_PROMO_DET SI_W_RTL_PROMO_IT_LC W_RTL_PROMO_IT_LC_D_J csv AIL_JOB DS_JOB OB STG_SI_PROMO_DETA IL_JOB REPL_DISTRO.cs W_RTL_REPL_DISTRO N/A – No SI jobs used W_RTL_REPL_DISTRO_IT v _IT_LC_DS_COPY_JOB LC_D_JOB W_RTL_REPL_DISTRO _IT_LC_DS_STG_JOB
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
Table 5-2 (Cont.) CSV File Process Flows
| Input Files (CSV) | RI_DIM_INITIAL_ADH OC (Step 1) | RI_DIM_INITIAL_ADHOC (Step 2) | RI_DIM_INITIAL_ADHOC (Step 3) |
|---|---|---|---|
| REPL_REV_INT.c sv | W_RTL_REPL_REV_IN T_IT_LC_DS_COPY_JOB W_RTL_REPL_REV_IN T_IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_REV_INT_IT_ LC_D_JOB |
| REPL_LT_INT.csv | W_RTL_REPL_LT_INT_ IT_LC_DS_COPY_JOB W_RTL_REPL_LT_INT_ IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_LT_INT_IT_L C_D_JOB |
| REPL_ROUND.cs v | W_RTL_REPL_ROUND _IT_LC_DS_COPY_JOB W_RTL_REPL_ROUND _IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_ROUND_IT_ LC_D_JOB |
| REPL_MULT_SU P.csv | W_RTL_REPL_MULT_S UP_IT_LC_DS_COPY_J OB W_RTL_REPL_MULT_S UP_IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_MULT_SUP_I T_LC_D_JOB |
| REPL_MULT_INT .csv | W_RTL_REPL_MULT_I NT_IT_LC_DS_COPY_J OB W_RTL_REPL_MULT_I NT_IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_MULT_INT_I T_LC_D_JOB |
| REPL_REV_SUP.c sv | W_RTL_REPL_REV_SU P_IT_LC_DS_COPY_JOB W_RTL_REPL_REV_SU P_IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_REV_SUP_IT _LC_D_JOB |
| REPL_LT_SUP.cs v | W_RTL_REPL_LT_SUP_ IT_LC_DS_COPY_JOB W_RTL_REPL_LT_SUP_ IT_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_LT_SUP_IT_L C_D_JOB |
| REPL_PROC.csv | W_RTL_REPL_PROC_I T_LC_DS_COPY_JOB W_RTL_REPL_PROC_I T_LC_DS_STG_JOB | N/A – No SI jobs used | W_RTL_REPL_PROC_IT_LC _D_JOB |
| STORE_COMP.cs v | COPY_SI_STORE_COM P_JOB STG_SI_STORE_COMP_ JOB | STAGING_SI_W_RTL_LOC_ COMP_MTX_DS_JOB | W_RTL_LOC_COMP_MTX_ D_JOB |
| SUPPLIER.csv | COPY_SI_SUPPLIER_JO B STG_SI_SUPPLIER_JOB | SI_W_PARTY_ORG_DS_JOB STAGING_SI_W_PARTY_AT TR_DS_JOB | W_PARTY_ATTR_D_JOB W_PARTY_ORG_D_JOB |
The table below provides the process flow for fact files in CSV format (applicable in both standalone and nightly cycles).
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
| Input Files (CSV) | File Load | Staging Load | Target Load |
|---|---|---|---|
| ADJUSTMENT.csv | COPY_SI_ADJUSTMENT _JOB STG_SI_ADJUSTMENT_J OB | SI_W_RTL_INVADJ_IT_ LC_DY_FS_JOB SI_INVADJ_W_DOMAIN _MEMBER_DS_TL_JOB | W_RTL_INVADJ_IT_LC_ DY_F_JOB W_DOMAIN_MEMBER_ LKP_TL_JOB |
| COST.csv | COPY_SI_COST_JOB STG_SI_COST_JOB | SI_W_RTL_BCOST_IT_L C_DY_FS_JOB SI_W_RTL_NCOST_IT_L C_DY_FS_JOB | W_RTL_BCOST_IT_LC_ DY_F_JOB W_RTL_NCOST_IT_LC_ DY_F_JOB |
| DEAL_INCOME.csv | COPY_SI_DEAL_INCOM E_JOB STG_SI_DEAL_INCOME _JOB | SI_W_RTL_DEALINC_IT _LC_DY_FS_JOB | W_RTL_DEALINC_IT_L C_DY_F_JOB |
| IC_MARGIN.csv | COPY_SI_IC_MARGIN_J OB STG_SI_IC_MARGIN_JO B | STAGING_SI_W_RTL_IC M_IT_LC_DY_FS_JOB | W_RTL_ICM_IT_LC_DY _F_JOB |
| INV_RECLASS.csv | COPY_SI_INV_RECLASS _JOB STG_SI_INV_RECLASS_J OB | STAGING_SI_W_RTL_IN VRECLASS_IT_LC_DY_F S_JOB | W_RTL_INVRECLASS_I T_LC_DY_F_JOB |
| INVENTORY.csv | COPY_SI_INVENTORY_J OB STG_SI_INVENTORY_JO B | SI_W_RTL_INV_IT_LC_ DY_FS_JOB | W_RTL_INV_IT_LC_DY_ F_JOB |
| INVENTORY_PACK.csv | COPY_SI_INVENTORY_ PACK _JOB STG_SI_INVENTORY_P ACK _JOB | SI_W_RTL_INVPK_IT_L C_DY_FS_JOB | W_RTL_INVPK_IT_LC_ DY_F_JOB |
| MARKDOWN.csv | COPY_SI_MARKDOWN _JOB STG_SI_MARKDOWN_J OB | SI_W_RTL_MKDN_IT_L C_DY_FS_JOB | W_RTL_MKDN_IT_LC_ DY_F_JOB |
| ORDER_DETAIL.csv | COPY_SI_ORDER_DETA IL_JOB STG_SI_ORDER_DETAIL _JOB | SI_W_RTL_PO_ONORD_ IT_LC_DY_FS_JOB | W_RTL_PO_ONORD_IT _LC_DY_F_JOB |
| PRICE.csv | COPY_SI_PRICE_JOB STG_SI_PRICE_JOB | SI_W_RTL_PRICE_IT_L C_DY_FS_JOB | W_RTL_PRICE_IT_LC_D Y_F_JOB |
| RECEIPT.csv | COPY_SI_RECEIPT_JOB STG_SI_RECEIPT_JOB | SI_W_RTL_INVRC_IT_L C_DY_FS_JOB | W_RTL_INVRC_IT_LC_ DY_F_JOB |
| RTV.csv | COPY_SI_RTV_JOB STG_SI_RTV_JOB | SI_W_RTL_INVRTV_IT_ LC_DY_FS_JOB | W_RTL_INVRTV_IT_LC _DY_F_JOB |
| SALES.csv | COPY_SI_SALES_JOB STG_SI_SALES_JOB | SI_W_RTL_SLS_TRX_IT _LC_DY_FS_JOB | W_RTL_SLS_TRX_IT_LC _DY_F_JOB |
| SALES_PACK.csv | COPY_SI_SALES_PACK_ JOB STG_SI_SALES_PACK_J OB | SI_W_RTL_SLSPK_IT_L C_DY_FS_JOB | W_RTL_SLSPK_IT_LC_ DY_F_JOB |
| SALES_WF.csv | COPY_SI_SALES_WF_JO B STG_SI_SALES_WF_JOB | STAGING_SI_W_RTL_S LSWF_IT_LC_DY_FS_JO B | W_RTL_SLSWF_IT_LC_ DY_F_JOB |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
| Input Files (CSV) | File Load | Staging Load | Target Load |
|---|---|---|---|
| SHIPMENT_DETAIL.csv | COPY_SI_SHIPMENT_D ETAIL_JOB STG_SI_SHIPMENT_DE TAIL_JOB | SI_W_RTL_SHIP_IT_LC_ DY_FS_JOB | W_RTL_SHIP_IT_LC_DY _F_JOB |
| TRANSFER.csv | COPY_SI_TRANSFER_JO B STG_SI_TRANSFER_JOB | SI_W_RTL_INVTSF_IT_ LC_DY_FS_JOB | W_RTL_INVTSF_IT_LC_ DY_F_JOB |
Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.
In this guide
- Guide: AI Foundation Operations Guide
- Previous: 4 AI Foundation Applications Standalone Processes
- Next: 6 Data Validation Framework
Related chapters
- 2 AI Foundation Data Standalone Processes — AI Foundation Operations Guide · shares
DAT_REPROCESS_ADHOC,DEAL_INCOME,DIFF_GROUP,EXCH_RATE - 10 Size Profiles — AI Foundation Implementation Guide · shares
DIFF_GROUP,PROD_SEASON,W_DOMAIN_MEMBER_LKP_TL,W_INT_ORG_ATTR_DS - 15 Inventory Planning Optimization — AI Foundation Implementation Guide · shares
REPL_DISTRO,REPL_LT_INT,REPL_LT_SUP,REPL_MULT_INT - 3 Planning and Flex Fact Configuration — Retail Insights Cloud Service Implementation Guide · shares
COPY_JOB,ETL_BUSINESS_DATE_JOB,OPY_JOB,STG_JOB - 6 Data Validation Framework — AI Foundation Operations Guide · shares
DAT_REPROCESS_ADHOC,W_DOMAIN_MEMBER_DS_TL,W_DOMAIN_MEMBER_LKP_TL,W_INT_ORG_DHS