My Oracle Support Banner

Warehouse Is Not a Location for StatusPageCommandLineApplication (Doc ID 2036005.1)

Last updated on MARCH 07, 2019

Applies to:

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


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.





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

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

In this Document

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