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 JUNE 21, 2018

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.3.0 and later
Information 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

Changes

 

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