My Oracle Support Banner

ORA-01422 Importing DLR into ASR multiple times cause DD completion to fail (Doc ID 878978.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Communications MetaSolv Solution Module - ASR - Version 37.0.0 to 38.0.0 [Release 37.0 to 38.0]
Information in this document applies to any platform.
Importing DLR into ASR


Symptoms

Users that had imported external DLRs into ASR multiple times were not able to complete the order, getting a data-related error message:

       java.sql.SQLException: ORA-01422: exact fetch returns more than requested
       number of rows|ORA-06512: at "ASAP.SP_CHANGE_CIRCUIT_STATUS", line
       2446|ORA-06512: at "ASAP.SP_COMPLETE_ASR", line 123|ORA-06512: at
       "ASAP.SP_TASK_COMPLETE", line 185|ORA-06512: at line 1|



Changes

 

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
Changes
Cause
Solution
References

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