Automated Move Of Backordered Materials Does Not Work after applying Patch 30812267:R12.WSH.C to Back-port this Feature from Release 12.2.9 (Doc ID 2672846.1)

Last updated on AUGUST 25, 2022

Applies to:

Symptoms

Customer applied patch patch 30812267:R12.WSH.C to backport two new shipping features from release 12.2.8 to releases 12.2.4 - 12.2.8. After applying this patch, the package body WMS_PICKING_AUDIT_PVT became invalid;  and the Automated Move of Backordered Materials did not function.   When attempting to re-compile this package, the following errors occur

ERROR
-----------------------
58/34 PL/SQL: ORA-00904: "WLPN"."LPN_STATE": invalid identifier
546/3 PL/SQL: SQL Statement ignored
564/14 PL/SQL: ORA-00904: "WLPN"."LPN_STATE": invalid identifier
582/8 PL/SQL: SQL Statement ignored

This error repeats 8 more times

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From a SQL*Plus session, enter the command
> alter package WMS_PICKING_AUDIT_PVT compile body;

2. Warning results:
Warning: Package Body altered with compilation errors.

3. Issue the show error command, see above errors

4. Test the 12.2.9 feature to move backordered materials to the source subinventory.   This did not function,  materials remained in the Staging subinventory

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users automate the move of backordered materials to the source subinventory.  This must still be done manually, as was done in earlier releases.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.