Approval_Date And Approval_id Were Removed After NewItemLocBatch
(Doc ID 2436748.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Retail Price Management - Version 13.2.8 and later
Information in this document applies to any platform.
Observe after running NewItemLocBatch, that RPM_CLEARANCE.APPROVAL_ID and RPM_CLEARANCE.APPROVAL_DATE are updated to NULL for an executed clearance.
RPM_CLEARANCE.APPROVAL_ID and RPM_CLEARANCE.APPROVAL_DATE should not be updated.
The issue can be reproduced at will with the following steps:
1. Create and approve an emergency clearance. Please make sure that at least one location is not ranged to the item
2. Check RPM_CLEARANCE table and make sure that APPROVAL_DATE and APPROVAL_ID have value
3. Range a location in RMS to the item
4. Run NewItemLoc
5. validate that APPROVAL_DATE and APPROVAL_ID become null in the RPM_CLEARANCE table
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document