My Oracle Support Banner

Records in PRICE_CHANGE_WORKSHEET Table Are Not Purged by Batch Purgepricechangeworksheet (Doc ID 2432535.1)

Last updated on FEBRUARY 22, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 15.0.1 and later
Information in this document applies to any platform.


The Oracle Retail Store Inventory Management (SIM) PurgePriceChangeWorksheet Batch does not purge the PRICE_CHANGE_WORKSHEET records.  

Steps to Recreate:

1. Set DAYS_TO_HOLD_PRICE_CHANGE_WORKSHEET parameter to 0 (for different parameter value query at 2. should be changed as well);

3. Backup the PRICE_CHANGE_WORKSHEET and ITEM_PRICE tables (or at least count the records number).
4. Execute the PurgePriceChangeWorksheet Batch without parameter.

Note that the PRICE_CHANGE_WORKSHEET table is not affected, while ITEM_PRICE table lost records with IDs from step (2).




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.