Change Order Errors: ORA-1407 OR FRM-40212 related to SCHEDULED_DATE OR STATUS_TYPE_OLD

(Doc ID 577675.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Product Hub - Version to [Release 11.5]
Oracle Engineering - Version to [Release 11.5]
Information in this document applies to any platform.


Problem Type 1 :

API to update a change order to implemented fails with the following error.

-- Error
ENCACN module: Engineering Change Order Implementation
Creating the parent event ecoImplement, change_id=1592143
After RAISE_ERES_EVENT(ecoImplement) msg_count=0, record_id=, status=NOACTION, ret=S
Others Error: ORA-01407: cannot update ("ENG"."ENG_REVISED_ITEMS"."SCHEDULED_DATE") to NULL

-- Steps
1. Run API
2. Get error.


Problem Type 2 :

When attempting to query ECO, the following error occurs.

FRM-40212: Invalid value for field STATUS_TYPE_OLD

The issue can be reproduced at will with the following steps:
1. Switch to Engineering Responsibility
2. Navigate to ECO form
3. Query ECO



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