Serial Number Does Not Get Populated In The Wsh_delivery_details Table , Where Is This Derived From ?

(Doc ID 1451458.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Shipping Execution - Version and later
Information in this document applies to any platform.


On : version, All Shipping Reports ACTUAL BEHAVIOR



Shipping Issue: Serial Number does not get populated in the wsh_delivery_details table.

Customers main issue is that the packing slip is not generating the serial number even thought there is a field present for it. 

Customer is looking for the serial numbers in the WSH_DELIVERY_DETAIL TABLE , Per review of the order mentioned via Diagnostic Order Information, the table that contains the serial numbers is WSH_SERIAL_NUMBERS table and MTL_SERIAL_NUMBERS_TEMP


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