My Oracle Support Banner

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 AUGUST 24, 2023

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.

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

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


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