Reloading Price Data
If you need to reload new price data from the beginning, you must first erase the pricing fact tables and clean up the configurations. There are two methods available for this and both should be used as of the current release:
-
Use the Data Cleanup Utility found in the AIF Operations Guide to truncate all price tables. You may use the subject area cleanup for this purpose, passing in a value of Price as the subject area name. This is required in order to efficiently delete any large volume tables, which performs better from this utility.
-
Use the history cleanup standalone process
HIST_DATA_CLEANUP_ADHOC
, which has only one job namedHIST_DATA_CLEANUP_JOB
. This job requires a module code as an input parameter, so pass in a value ofPRICE
to erase price data. This job will also take care of resettingC_HIST_LOAD_STATUS
data for pricing loads. This can run after the first step and will take care of price historyTMP
table cleanup that the support utility does not do.
Make sure you check C_HIST_LOAD_STATUS
before starting a new price 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.