My Oracle Support Banner

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


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|


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.