Import Supplement ASR For Ethernet Orders Receive Error "ORA-02292: integrity constraint ASAP.PFXFK_EVC_DETAIL__FOC_EVC_DET"

(Doc ID 1439013.1)

Last updated on MAY 09, 2012

Applies to:

Oracle Communications MetaSolv Solution Module - ASR - Version 43.0.0 and later
Information in this document applies to any platform.

Symptoms

The initial version of an ASR with EVC forms associated imports into MetaSolv Solution Software (MSS) correctly. On these orders, a Confirmation Notice is generated and sometimes the CONF task is completed. Subsequently a supplement is transmitted by the customer. The supplement order does not import successfully. The import fails with the following error message:

java.sql.SQLException: ORA-02292: integrity constraint ASAP.PFXFK_EVC_DETAIL__FOC_EVC_DET) violated - child record found


This pattern is consistent with every Ethernet ASR order (ASR with EVC form associated) that is supplemented. This is a significant impact to the order processing function.

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