Invalid WMS_CARTNZN_PUB After Applying Some Patches

(Doc ID 1674074.1)

Last updated on MARCH 08, 2017

Applies to:

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

  1. You applied some patches (18076740, 16858759, 14849416) for Oracle Sourcing, PO and Inventory issues
  2. Now WMS_CARTNZN_PUB has become invalid and not compiling



Changes

Applied Patches 18076740, 16858759, 14849416.

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