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 11.5.10.2 to 11.5.10.2 [Release 11.5]
Oracle Engineering - Version 11.5.10.0 to 11.5.10.0 [Release 11.5]
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
FRM-40212: Invalid value for field STATUS_TYPE_OLD

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

 

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