Error completing Due Date (DD) task; java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN) violated - child record found

(Doc ID 946129.1)

Last updated on JANUARY 02, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 05-03-2013***

Symptoms

The Due Date task cannot be completed because of a "java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN) violated - child record found" error.

Screenshot of error:

Error text:

A data-related error occurred. Please use the detail button for more information.

java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN)
violated - child record foundORA-06512: at
"ASAP.SP_REMOVE_BASE_TFC_ASSIGNMENTS",line 104ORA-06512: at
"ASAP.SP_CHANGE_CIRCUIT_STATUS",line 1675ORA-06512: at
"ASAP.SP_COMPLETE_PSR",line 48ORA-06512: at "ASAP.SP_TASK_COMPLETE",
line 187ORA-06512: at line 1

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