After Patch Upgrade Agile e6.1.2.2 to Agile e6.1.3.0 - CAX_STRUCTUR_PKG returns compilation error "PL/SQL: ORA-00904: "POS_NO": invalid identifier" On T_CAX_FIL_TMP
(Doc ID 2010036.1)
Last updated on NOVEMBER 12, 2019
Applies to:
Oracle Agile Engineering Data Management - Version 6.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
After running Patch upgrade from e6.1.2.2 to e6.1.3, the PL/SQL procedure CAX_STRUCTUR_PKG returns compilation error "PL/SQL: ORA-00904: "POS_NO": invalid identifier"
due to wrong T_CAX_FIL_TMP tmp table definition.
EXPECTED BEHAVIOR
--------------------------------
no errors
STEPS:
---------------------
1. Run Patch upgrade from e6.1.2.2 to e6.1.3.
2. Observe "logfile "del_and_save_lvmodel.log".
3. Find error.
CAX_STRUCTUR_PKG PACKAGE BODY 1 1544 12 PL/SQL: ORA-00904: "POS_NO": invalid identifier ERROR
BUSINESS IMPACT
-------------------------
CAX_STRUCTUR_PKG is invalid and can not be compiled. CAD files can not be loaded by quick load function
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 |