Reloading Inventory Data
If you need to reload new inventory data from the beginning, you must first erase the inventory fact tables and clean up
the configurations. Use the Data Cleanup Utility described in the AIF Operations Guide to truncate all inventory fact
tables. You should use the subject area cleanup for this purpose, passing in a value of Inventory Position as the subject area name. This utility when run for the inventory subject area will truncate the tables, reset the columns
in C_HIST_LOAD_STATUS
, and cleanup metadata relating to the partitions to prepare it for a fresh load of
data. It will not truncate TMP
tables, as those will be truncated automatically when the history load programs
are executed.
Make sure you check C_HIST_LOAD_STATUS
before starting a new inventory load as you may want to enable
different tables or change the HIST_LOAD_LAST_DATE
values to align with your new data. Verify that the MAX_COMPLETED_DATE
and HIST_LOAD_STATUS
columns are null for all rows you will be reprocessing.