INV_RESERVATION_GLOBAL_W Invalid Package Body After 12.2.6 Upgrade Driver 21900901

(Doc ID 2268903.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Patch Application Issues

Invalid package body INV_RESERVATION_GLOBAL_W after 12.2.6 upgrade driver 21900901

Following Doc ID 2114016.1 to upgrade from 12.2.5 to 12.2.6.

Post upgrade driver below package body became invalids.

APPS INV_RESERVATION_GLOBAL_W PACKAGE BODY INVALID

SQL> alter package apps.INV_RESERVATION_GLOBAL_W compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.INV_RESERVATION_GLOBAL_W:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3291/11 PL/SQL: Statement ignored
3291/21 PLS-00302: component 'MAX_PICKS_BATCH' must be declared
3294/11 PL/SQL: Statement ignored
3294/21 PLS-00302: component 'DEFAULT_TASK_ASSIGN_RULE_ID' must be declared

3295/11 PL/SQL: Statement ignored
3295/21 PLS-00302: component 'DEFAULT_LABEL_COMP_RULE_ID' must be declared

4334/11 PL/SQL: Statement ignored
4334/58 PLS-00302: component 'MAX_PICKS_BATCH' must be declared
4337/11 PL/SQL: Statement ignored
4337/58 PLS-00302: component 'DEFAULT_TASK_ASSIGN_RULE_ID' must be declared

4338/11 PL/SQL: Statement ignored
4338/58 PLS-00302: component 'DEFAULT_LABEL_COMP_RULE_ID' must be declared

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