Import Supplement ASR For Ethernet Orders Receive Error "ORA-02292: integrity constraint ASAP.PFXFK_EVC_DETAIL__FOC_EVC_DET"
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms