Customer Center Throws Error While Accessing Plans Tab : "fm_subs_rap_set_deal_nodes error"

(Doc ID 1983792.1)

Last updated on MARCH 03, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms

On : BRM 7.3.1.0.0 version, Customer Center [CC]

In a scenario where some purging activity has been carried out on cancelled products, customer center is throwing error while accessing the Plans tab.

Error in CM pinlog :


Scenarios :

(1)
--  Let us say, /purchased_product P1 has been cancelled on an account
--  Let us say, P1 and its audit has been deleted in the database as per some custom business requirement
--  Let us consider, a CSR is accessing the Plans tab of this account ( to which P1 belongs)
--  selected ACTIVE and CANCELLED products under 'Customize Plan Table'.
--  now Customer Center will throw error.

Expected : CC not to throw error and show the active and cancelled product

(2)
--  Let us say, /purchased_product P1 has been cancelled on an account
--  Let us say, P1 and its audit has been deleted in the database as per some custom business requirement
--  Let us consider, a CSR is accessing the Plans tab of this account ( to which P1 belongs)
--  selected ACTIVE  products only under 'Customize Plan Table'
--  now Customer Center will throw error .

Expected : CC not to throw error but show all ACTIVE products

(3)
--  Let us say, /purchased_product P1 has been canceled on an account
--  Let us say, /purchased_product P2 has been canceled on an account
--  Let us say, P1 and its audit has been deleted in the database as per some custom business requirement
--  Let us say, P2 and its audit has NOT been deleted in the database as per some custom business requirement
--  Let us consider, a CSR is accessing the Plans tab of this account ( to which P1 and P2 belongs)
--  selected ACTIVE  and CANCELLED products under 'Customize Plan Table'
--  CC will thrown an error

Expected : CC not to throw error, but show all ACTIVE products and CANCELLED products


Cause

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