Deleting a Newly Created Clearance With a Reset Date Does Not Work As Expected, Resulting in Incorrect Item Price Being Displayed (Doc ID 2083470.1)

Last updated on JULY 15, 2022

Applies to:

Symptoms

For an item which is already on clearance when a new clearance with a reset date is created, the system updates the ITEM_PRICE.END_DATE of the previous existing clearance record with the effective date of the reset clearance record.  However, if this newly created clearance with the reset date is deleted, the END_DATE of the previous clearance is not cleaned up.

This results in Store Inventory Management (SIM) showing the regular retail for that item, even though the previous existing clearance is still active.

Steps To Recreate:

1. Select a Item which is already on Clearance.
2. For this item process a new clearance with reset date and a reset clearance.
3. Approve clearance.
4. Run batch jobs to extract the price change files and apply to SIM
5. Set the reset date as null for this clearance and approve.
6. Delete this newly created clearance say by moving to worksheet.
7. Run batch jobs to extract the price change files and apply to SIM.
8. It is observed that after deleting, the end date for the old clearance is not cleared . Due to which the item goes back to permanent price.

Changes

Cause

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