My Oracle Support Banner

SIM Inventory Adjustment Records Without a COMPLETE_DATE Are Not Purged (Doc ID 2445845.1)

Last updated on MAY 27, 2020

Applies to:

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


In Oracle Retail Store Inventory Management (SIM), the inventory adjustment records with complete status but where the COMPLETE_DATE value is NULL, are not getting purged from the system.

Steps to Recreate:

1. Check the RK_CONFIG and noticed that the DAYS_TO_HOLD_COMPLETED_INV_ADJ is set to '1'.
2. Check the RK_INV_ADJUSTMENT and take a note of the records that have the COMPLETE_DATE as NULL.
3. Run ./ batch.
Notice that all the records with COMPLETE_DATE were purged but the ones from step (2) were not.


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.