My Oracle Support Banner

APPROVAL_DATE And APPROVAL_ID Have Null In RPM_CLEARANCE_RESET Table (Doc ID 2248742.1)

Last updated on MARCH 29, 2017

Applies to:

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

Symptoms

Approval date is missing for clearance reset records in RPM_CLEARANCE_RESET table, APPROVAL_DATE and APPROVAL_ID both are NULL.

Steps to reproduce:

  1.  Create clearance without reset date and approve it
  2.  Close Oracle Retail Price Management(RPM) screen and check RPM_CLEARANCE_RESET table.
  3.  Open clearance through maintain clearance window and insert reset date and apply

APPROVAL_DATE and APPROVAL_ID both are NULL in RPM_CLEARANCE_RESET

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!

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