RPM LocationMoveBatch Fails With ORA-06503 Error (Doc ID 1946313.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Retail Price Management - Version 13.2.5 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Price Management (RPM) 13.2.x, LocationMoveBatch fails with the following error in case of unexpected exceptions.


This issue occurs as the following functions in RPM_LOC_MOVE_SQL package return no value in case of unexpected exceptions.
  1. RPM_LOC_MOVE_SQL.SCHEDULE_LOCATION_MOVE
  2. RPM_LOC_MOVE_SQL.COMPLETE_LOCATION_MOVE

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