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 24, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.1 and later
Information 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

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