My Oracle Support Banner

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 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

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


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