My Oracle Support Banner

12.2.9 Upgrade Fails To Compile Objects INVADPTE.pll and WMSTXERE.pll (Doc ID 2713281.1)

Last updated on OCTOBER 25, 2020

Applies to:

Oracle Warehouse Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade a 12.1.3 instance to 12.2.9, we received the following error at the end of the patching:

The following Oracle Forms objects did not generate successfully:

au resource INVADPTE.pll
au resource WMSTXERE.pll

The following errors can be seen in the patch logs:

Compiling library WMSTXERE...
ERROR 201 at line 1187, column 15
 identifier 'INVENTORY_LOCATION_ID' must be declared
ERROR 0 at line 1185, column 7
 SQL Statement ignored
Closing library WMSTXERE...
Compilation errors on WMS_RCV_TRANSACTION_6:
PL/SQL ERROR 201 at line 1187, column 15
identifier 'INVENTORY_LOCATION_ID' must be declared
PL/SQL ERROR 0 at line 1185, column 7
SQL Statement ignored

Compilation errors on WMS_TAG_ENTRIES:
PL/SQL ERROR 302 at line 243, column 45
component 'CONCATENATED_SEGMENTS' must be declared
PL/SQL ERROR 0 at line 243, column 22
Item ignored
PL/SQL ERROR 201 at line 316, column 40
identifier 'INVENTORY_LOCATION_ID' must be declared
PL/SQL ERROR 0 at line 315, column 6
SQL Statement ignored
PL/SQL ERROR 320 at line 319, column 6
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 319, column 6
Statement ignored
PL/SQL ERROR 320 at line 338, column 28
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 336, column 17
Statement ignored

Compilation errors on WMS_RCV_TRANSACTION_6:
PL/SQL ERROR 201 at line 1187, column 15
identifier 'INVENTORY_LOCATION_ID' must be declared
PL/SQL ERROR 0 at line 1185, column 7
SQL Statement ignored




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


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