My Oracle Support Banner

INV_RESERVATION_GLOBAL_W Invalid Package Body After 12.2.6 Upgrade Driver 21900901 (Doc ID 2268903.1)

Last updated on APRIL 30, 2019

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
-------- -----------------------------------------------------------------
1000/11 PL/SQL: Statement ignored
1001/21 PLS-00302: component 'MAX_PICKS_BATCH' must be declared
1002/11 PL/SQL: Statement ignored
1002/21 PLS-00302: component 'DEFAULT_TASK_ASSIGN_RULE_ID' must be declared

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

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

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

Changes

 

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


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