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

Last updated on DECEMBER 04, 2009

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|



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