WSHPSGL: Pick Selection List Generation Errors Out : ORA-06508: PL/SQL: could not find program unit being called
(Doc ID 1295452.1)
Last updated on JULY 08, 2020
Applies to:
Oracle Warehouse Management - Version 12.1.1 and laterInformation in this document applies to any platform.
Inv_Pick_Release_Pub.Pick_Release, ORA-06508, WSHPSGL, Pick Release, WMS_CARTNZN_PUB
Symptoms
On : 12.1.1 version, Pick Release Process
When attempting to pick release,the following error occurs.
ERROR
-----------------------
[26-JAN-11 12:06:54] WMS_DEVICE_INTEGRATION_PVT: No device exist in this Org4045
[26-JAN-11 12:06:54] PICKREL: headeR_id for line index 1 is 3035451
[26-JAN-11 12:06:54] PICKREL: calling cartonize api
[26-JAN-11 12:06:54] PICKREL: Other error: ORA-06508: PL/SQL: could not find program unit being called
Error occurred in Inv_Pick_Release_Pub.Pick_Release
ORA-06508: PL/SQL: could not find program unit being called in Package INV_Pick_
Release_PUB Procedure Pick_Release
Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Internal Requisition=> Destination WMS organization
2. Done Order Import => Run pick release
Cause
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
| Symptoms |
| Cause |
| Solution |