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 JULY 11, 2016

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.3.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------------
On Agile 6.1.3.0

Find after running Patch upgrade from e6.1.2.2 to e6.1.3 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

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