C_HIST_LOAD_STATUS
The C_HIST_LOAD_STATUS
table is used to track the progress of historical loads of data, primarily inventory
position and pricing facts. You should edit the following fields on this table based on your implementation needs:
-
HIST_LOAD_LAST_DATE
– Specifies the planned final date for the end of your historical loads (for example, the end of the 2-year period you plan to load into RAP). The history load programs will assume that you are providing each week of inventory in sequence from earliest to latest and process the data in that order. -
ENABLED_IND
– Turns on or off a specific table load for historical data. Most of the tables in these processes are only required for Retail Insights, and the rest can be disabled to improve performance. Set to a value of N to disable a table load. -
MAX_COMPLETED_DATE
– The load programs use this to keep track of the last loaded week of data. It does not allow you to reload this week or any prior week, so if you are trying to start over again after purging some history, you must also reset this field. -
HIST_LOAD_STATUS
– The load programs uses this to track the status of each step in the load process. If your program gets stuck on invalid records change this field back toINPROGRESS
before re-running the job. If you are restarting a load after erasing history data, then you need to clear this field of any values.
If you are implementing Retail Insights, then enable all INV and PRICE modules in the table (set ENABLED_IND
to Y
). If you are only implementing AI Foundation or Planning application modules, then the following history
tables should be enabled; all others should be disabled (set ENABLED_IND
to N
).
-
W_RTL_PRICE_IT_LC_DY_F
-
W_RTL_PRICE_IT_LC_DY_HIST_TMP
-
W_RTL_INV_IT_LC_DY_F
-
W_RTL_INV_IT_LC_WK_A
-
W_RTL_INV_IT_LC_DY_HIST_TMP
After enabling your desired history load tables, update the value of HIST_LOAD_LAST_DATE
on all rows you
enabled. Set the date equal to the final date of history to be loaded. This can be changed later if you need to set the date
further out into the future.
As you load data files for one or more weeks of history per run, the value of MAX_COMPLETED_DATE
and HIST_LOAD_STATUS
automatically update to reflect the progress you have made. If you need to restart the process
(for example, you have loaded test data and need to start over with production data) these two columns must first be cleared
of all data from the Control Center before beginning the history load again.