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.
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".
Oracle Communications MetaSolv Solution
An error occurred in sp_rules.
ORA-01403: no data found event_id:-
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
SELECT plan_name, prov_plan_type_cd
INTO plan_nm, type_cd
WHERE plan_id = prov_plan_id AND active_ind = 'Y';
plan_nm := '';
type_cd := 0;
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