"Error ORA-06502: PL/SQL: numeric or value error returned by program unit DISTRIBUTION_SQL.OUTBOUND_DIST_RULE_1" when Creating Outbound Inventory Adjustments
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.
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 :
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