During a Full warehouse extraction and load, existing data is erased from tables in Oracle Business Analytics Warehouse and new data is populated. In the case of Aggregate or Snapshot tables, this can result in the loss of historical data which has been accumulated over time. Once erased, such historical data cannot easily be replaced.
To preserve Snapshot data from Inventory Balance aggregate tables (Inventory Monthly Balance and Inventory Lot Monthly Balance), mappings have been created that will copy the data to temporary tables at the beginning of a Full load and then restore the copied data back into the Snapshot tables once the Full load is complete. These mappings will only execute during a Full load.
Additionally, in order to enable the copy and restore process, the associated parameter, RESTORE_INV_MONTHLY_BAL, must be set to Y. If you do NOT wish to copy and restore data from the Inventory Balance Snapshot tables during a Full load, then set the value for this parameter to N (or any value other than Y).