1. Implementation Guide
  2. Data Loads and Initial Batch Processing
  3. Loading Data from Files
  4. Load History Data
  5. Reloading Price Data

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:

  1. 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.

  2. Use the history cleanup standalone process HIST_DATA_CLEANUP_ADHOC, which has only one job named HIST_DATA_CLEANUP_JOB. This job requires a module code as an input parameter, so pass in a value of PRICE to erase price data. This job will also take care of resetting C_HIST_LOAD_STATUS data for pricing loads. This can run after the first step and will take care of price history TMP 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.