My Oracle Support Banner

Approval_Date And Approval_id Were Removed After NewItemLocBatch (Doc ID 2436748.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Retail Price Management - Version 13.2.8 and later
Information in this document applies to any platform.

Symptoms

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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