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 to [Release 7.5.0]
Information in this document applies to any platform.


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.

-- Constant values

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;


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