Purchased_product_t.plan_* Feilds Incorrectly Populated by CMT (Doc ID 1946302.1)

Last updated on DECEMBER 09, 2014

Applies to:

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

Symptoms

On BRM 7.5PS6, CMT

Purchased_product_t.plan_* fields are incorrectly populated by CMT.

For account level products, the Purchased_product_t.plan_obj* must be populated with
Purchased_product.plan_obj_id0 = 0
Purchased_product.plan_obj_type = NULL

However, in the CMT provided CTL file (purchased_product_t.ctl), a constant value of '/plan' is always forced to be inserted to the plan_obj_type field.

Eg:
-- Constant values
  PLAN_OBJ_TYPE CONSTANT '/plan',
  PLAN_OBJ_REV CONSTANT '0',

So, it is corrupted data in the purchased_product_t table where
plan_obj_id0 = 0 & PLAN_OBJ_TYPE = '/plan' --> For account_level products (product_t.permitted = '/account')

The below query must not return anything after import:
  select * from PURCHASED_PRODUCT_T PP where plan_obj_id0 = 0 and PLAN_OBJ_TYPE is not null;




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