My Oracle Support Banner

Error Occurred in SP_RULES - "ORA-01722: invalid number event_id:-{NBR}" During Provisioning Plan Assignment (Doc ID 2946460.1)

Last updated on OCTOBER 19, 2023

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.1 and later
Information in this document applies to any platform.

Symptoms

When assigning a Provisioning Plan to a PSR order, Task Behaviors (Insert Task/Delete Task) are not being applied as configured for a Rules and Behaviors event that is based on User Data fields. The error below is received in the GUI during Provisioning Plan Assignment immediately after clicking the "Get Tasks" button. After acknowledging the error, the desired task is not on the Task List tab to be inserted.

 

ERROR

An error occurred in sp_rules.

ORA-01722: invalid number event_id:-{NBR}

 

 

The configuration information below can be used to recreate the problem. Once configured, create a PSR order with the appropriate User Data field that will trigger the Rules and Behaviors event when assigning a Provisioning Plan.

User Data Category Configuration

Product Service Request User Data Configuration

Rules and Behaviors Configuration Summary

 

Changes

Created new Rules and Behavior event for User Data field configured using a User Data Category of BOOLEAN.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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