My Oracle Support Banner

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.


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.


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

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