SP_PSR_CNAM_LIDB_SUPP failed error during PSR Supp Cancel process (Doc ID 1340150.1)

Last updated on JULY 25, 2017

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.


Users receive a SP_PSR_CNAM_LIDB_SUPP procedure error while supp canceling a PSR order with a telephone number that is pending disconnect.   The message displays immediately after selecting YES to the "You have chosen to Supp - Cancel!" message."  The order appears to cancel.   After clicking OK to the "A Cancel Supplement Order has been created" message, the Order Info tab fields are all greyed out and the Supp Type field displays "1 - Cancel".   All the tasks are in a status of 'Ready' and the order's notes has "A SUPP type of 'Cancel' was applied to this order." entry.   However, refreshing the Service Request Search results shows the Supplement Type is not "1 - Cancel".   Below are the error message details.

Screenshot of Error


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