SP_DELETE_ASSIGNMENT(10:) ORA-01422 error attempting to unassign a telephone number from a PSR order
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.
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