Unapproval of Clearance Results in ORA-01438 Error
Last updated on JULY 27, 2017
Applies to:Oracle Retail Price Management - Version 14.1.1 and later
Information in this document applies to any platform.
Unapproval of a clearance results in the following error:
Steps to reproduce:
1. Login to RPM.
2. Navigate to Clearances-> Create Clearance.
3. Create 11 clearances on an item/loc and approve the same for successive dates.
4. RPM_FUTURE_RETAIL should have clear_mkdn_index = 11 for the last clearance.
5. Unapprove the last clearance.
6. Note that unapproval process throws above error.
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