Coding Serial Hook (INV_DETAIL_SERIAL_PUB) To Skip Serials Causes Backorders And ORA-06502 (Doc ID 2190975.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.
INV_DETAIL_SERIAL_PUB
ORA-06502
INV_DETAIL_SERIAL_PUB.Get_User_Serial_Numbers
Get_User_Serial_Numbers
User-Defined

Symptoms

Pick release backorders when material is available but the custom "user-defined" serial hook filters out serials as invalid.

Expected Behavior
User expects serial hook to skip some serials, then pick release to continue looking for other available quantity in other locations.

What is working
* In these examples, a rule is setup to pick by subinventory order. Here are case that work and one that fails:
a) Works if ...full quantity in primary subinventory...
b) Works if ...partial quantity in primary subinventory, and remaining in second subinventory...
c) Works if ... no quantity in primary, but have enough in second subinventory...
d) Fails if ... full quantity in primary, but serial hook skips those serials as not eligible.

Error

 

Setup
1. Inventory parameter "Allocate Serial number" is set to "Yes - User Defined".
2. Code custom logic in "INV_DETAIL_SERIAL_PUB.Get_User_Serial_Numbers". (See <Note 1332302.1>).
3. Create pick rule by subinventory.
4. Add pick order on each subinventory.
5. Have quantity for serialized part in multiple locations available.
6. Pick release rule does not specify a specific subinventory on pick release form.

Steps
1. Perform setup to enable custom hook.
2. Attempt to pick release Sales Order.
3. Pick Release fails and backorders.

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