"Error ORA-06502: PL/SQL: numeric or value error returned by program unit DISTRIBUTION_SQL.OUTBOUND_DIST_RULE_1" when Creating Outbound Inventory Adjustments (Doc ID 1664287.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

When an outbound inventory adjustment was created for a physical non stockholding warehouse, ORA Error 06502 was encountered.

Instructions to Re-create:

1. Select an item and a non stockholding physical warehouse such that item is not ranged to any of the virtual warehouses within the physical warehouse.
2. Run RMSSUB_INVADJ to simulate the externally generated outbound inventory adjustment creation (from ATS to NULL).
3. Observe the following error : 

 

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