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.