My Oracle Support Banner

Telephone number stuck in 'Pending' status after application improperly unassigned it from PSR order (Doc ID 1184061.1)

Last updated on AUGUST 23, 2010

Applies to:

Oracle Communications MetaSolv Solution - Version: 6.0.15 and later   [Release: 6.0.15 and later ]
Information in this document applies to any platform.


Telephone number stuck in 'Pending' status after application improperly unassigns them from the PSR order.  The problem occurs when attempting to remove a telephone number from the order via the 'Inventory and Assign' tab of the 'Assign Telephone Numbers' window (un-assign ) that was already sent to the 911 provider.  The application displays two error messages (see below), but removes the telephone number anyway and leaves it in a 'Pending' status. 

"Error in procedure.

SP_DELETE_ASSIGNMENT(180:E911 has been extracted from this number. You can not delete this number.)."

"Error unassigning telephone number XXX-XXX-XXXX

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.