Invalid WMS_CARTNZN_PUB After Applying Some Patches
(Doc ID 1674074.1)
Last updated on JULY 08, 2020
Applies to:
Oracle Warehouse Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Install
Invalid WMS_CARTNZN_PUB after applying some patches.
ERROR
-----------------------
Warning: Package Body altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY APPS.WMS_CARTNZN_PUB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8191/10 PL/SQL: SQL Statement ignored
8192/11 PL/SQL: ORA-00947: not enough values
8215/10 PL/SQL: SQL Statement ignored
8216/11 PL/SQL: ORA-00947: not enough values
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- You applied some patches (18076740, 16858759, 14849416) for Oracle Sourcing, PO and Inventory issues
- Now WMS_CARTNZN_PUB has become invalid and not compiling
Changes
Applied Patches 18076740, 16858759, 14849416.
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 |
Changes |
Cause |
Solution |
References |