Purchased_product_t.plan_* Feilds Incorrectly Populated by CMT
Last updated on DECEMBER 09, 2014
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [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
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;
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