My Oracle Support Banner

SP_RULES ORA-01403 Error When Supplementing Order With Inactive Provisioning Plan (Doc ID 2866804.1)

Last updated on MAY 03, 2022

Applies to:

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

Symptoms

SP_RULES throws an "ORA-01403" error when attempting to process supplement an order and a Provisioning Plan associated with the order has been marked as 'Inactive'. Below is the complete error text including its "<< Details".


ERROR

Oracle Communications MetaSolv Solution

An error occurred in sp_rules.
ORA-01403: no data found event_id:-


Additional Information

Code below parsed from SP_RULES. If the Provisioning Plan associated to the order has been set as 'Inactive', this query returns no rows and throws the exception.


========================
--Select query to retrieve prov plan type
IF prov_plan_id IS NOT NULL
THEN
  SELECT plan_name, prov_plan_type_cd
  INTO plan_nm, type_cd
  FROM asap.provisioning_plan
  WHERE plan_id = prov_plan_id AND active_ind = 'Y';
ELSE
 plan_nm := '';
 type_cd := 0;
END IF;

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
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.