ORA-00904: CHECK_SKILL: Invalid Identifier In ECO Form - Upgrade From 11.5.10 To 12.1.3 (Doc ID 2204598.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Engineering - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 11.5.10 to 12.1.3, Customer is getting ORA-00904: CHECK_SKILL: Invalid Identifier in ECO Form.

In an Engineering Change Order, when trying to open the Operations form, an error is popping up:

ERROR
-----------------------
ORA-00904: CHECK_SKILL: Invalid Identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to ECO's > ECOs
2. Query the ECO
3. Click the 'Revised Items' button
4. In the Revised Items form, click 'Operations'
5. In the Revised Operations form, note the error "ORA-00904: "CHECK_SKILL": invalid identifier


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