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

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