My Oracle Support Banner

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 JULY 06, 2020

Applies to:

Oracle Shipping Execution - Version 12.2.4 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.


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

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

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

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.


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

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