WSHPSGL: Pick Selection List Generation Errors Out : ORA-06508: PL/SQL: could not find program unit being called

Issue:

WSHPSGL: Pick Selection List Generation Errors Out : ORA-06508: PL/SQL: could not find program unit being called

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:

Package WMS_CARTNZN_PUB  is invalid.

If compiling package WMS_CARTNZN_PUB you get :

Errors for PACKAGE BODY APPS.WMS_CARTNZN_PUB:
8027/10 PL/SQL: SQL Statement ignored
8027/21 PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got
DATE

Solution:

1. Download and review the readme and pre-requisites for Patch 17794932:R12.INV.B

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
 
WMS_CARTONIZATION_TEMP.xdf 120.4.12010000.8

5. Retest the issue.

Reference:

WSHPSGL: Pick Selection List Generation Errors Out : ORA-06508: PL/SQL: could not find program unit being called (Doc ID 1295452.1)

  • December 31, 2018 | 25 views
  • Comments