SP_DELETE_ASSIGNMENT(10:) ORA-01422 error attempting to unassign a telephone number from a PSR order (Doc ID 781887.1)

Last updated on AUGUST 07, 2009

Applies to:

Oracle Communications MetaSolv Solution - Version: 6.0.15 to 6.0.15
This problem can occur on any platform.


An "ORA-01422: exact fetch returns more than requested number of rows" error is thrown by the SP_DELETE_ASSIGNMENT stored procedure when attempting to remove a telephone number from a PSR order that had already been mapped to an LSR order.  Below are the errors displayed in the GUI:



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