Pick Slip Number Is Not Getting Generated Hence Pick Slip Report Not Getting Printed

(Doc ID 1459501.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Warehouse Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.


When attempting to process pick release ,
the following error occurs.

[22-JAN-12 20:29:31] WMS_CARTNZN_PUB: 2012-01-22 08:22:31Exception occurred from ERROR_CODE:CARTONIZE 110
[22-JAN-12 20:29:31] PICKREL: error from cartonize api
[22-JAN-12 20:29:31] PICKREL: error count 2
[22-JAN-12 20:29:31] PICKREL: error msg
[22-JAN-12 20:29:31] PICKREL: Device_API: return stat:
[22-JAN-12 20:29:31] PICKREL: Final x_return_status is E
Error occurred in Inv_Pick_Release_Pub.Pick_Release
SQLCODE: -6502 SQLERRM: ORA-06502: PL/SQL: numeric or value error
Exception occurred in WSH_PICK_LIST

The issue can be reproduced at will with the following steps:
1. Submit Pick Release for WMS Enabled Organization
2. Get 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