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:
SP_DELETE_ASSIGNMENT(10:). ORA-01422: exact fetch returns more than requested number of rows
Please contact support.
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