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.

Symptoms

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.

Changes

Cause

	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 hundreds of Community platforms