12.2.9 Upgrade Fails To Compile Objects INVADPTE.pll and WMSTXERE.pll
(Doc ID 2713281.1)
Last updated on AUGUST 24, 2023
Applies to:
Oracle Warehouse Management - Version 12.2.9 and laterInformation 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
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
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 |
| Cause |
| Solution |
| References |