Last updated on JULY 24, 2017
Applies to:Oracle Retail Price Management - Version 13.2 to 13.2.9 [Release 13.2]
Oracle Retail Price Management - Version 13.0 to 13.0.7 [Release 13.0]
Information in this document applies to any platform.
This article will be updated as official patch information becomes available.
RPM clearance maintenance screen allows to select the reset date older than vdate date to reset the clearance that is already in executed state.
Steps To Recreate:
1. Log on to RPM
2. Take any executed clearance from maintain clearance screen, and change the reset prior to vdate.
3. Click on apply button, it changes status to Conflict check
4. In the application it throws the below in the Alert section
5. Clearance Conflict Check Complete with below error:
PACKAGE_ERROR@1ORA-01400: cannot insert NULL into ("RMS13"."RPM_CLEARANCE_PAYLOAD"."CLEARANCE_ID")@2RPM_CC_PUBLISH.STAGE_CLR_MESSAGES
exception id: 1458197028586
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms