My Oracle Support Banner

Unapproval of Clearance Results in ORA-01438 Error (Doc ID 2226967.1)

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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