Warehouse Is Not a Location for StatusPageCommandLineApplication

(Doc ID 2036005.1)

Last updated on APRIL 30, 2018

Applies to:

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

Symptoms

In Oracle Retail Price Management (RPM), 'Warehouse' is marked in system options as not a location, but the statusPageCommandLineApplication batch does not check this condition.


Steps to Reproduce:

  1. Ensure that RPM_SYSTEM_OPTIONS for RECOGNIZE_WH_AS_LOCATIONS=0, which means the warehouse is not part of the RPM locations.
  2. There are item_location records warehouse location LOC_TYPE='W'.
  3. Same is not present in RPM_FUTURE_RETAIL, as warehouse is not a location in RPM.
  4. Run the statusPageCommandLineApplication batch.  It results in a data integrity issue, missing item location in RPM_FUTURE_RETAIL.

 

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