My Oracle Support Banner

Error 'ORA-06502: PL/SQL: Numeric Or Value Error' Occurs When Splitting the Order Using Truck Splitting Functionality (Doc ID 2555018.1)

Last updated on OCTOBER 10, 2019

Applies to:

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


When using the truck splitting functionality to split an order, getting below error message :

Steps to Recreate:

  1.  Create a Purchase Order from a supplier to a Warehouse. ( make sure to fill pickup_location as text value but not number).
  2. Add an item.
  3. In the screen 'Inventory Management' on the PO creation add some truck constraint information:

              Truck split method = Item Sequence
              Constraints 1 = Each
              Value = 48
              Tolerance = 1

       4.Save the order - Don't approve it.

       5. Search the order and use the functionality : Split order. Error ORA-06502 occurs.





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.