Issue With Pin_rel Behavior With Virtual Columns Feature (Doc ID 1552050.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Linux x86-64
***Checked for relevance on 4-May-2015***

Symptoms

We notice that with virtual columns enabled, pin_rel is updating poid_type values to respective IDs for all occurences of poid_type vales in the rated out file.

i.e. The columns virtualized under /event class are :
pod_type
account_obj_type
group_obj_type
item_obj_type
provider_id_type
service_obj_type
session_obj_type
rerate_obj_type
userid_type
loader_batch_obj_type

columns virtualized under event_bal_impacts are :
account_obj_type
bal_grp_obj_type
item_obj_type
product_obj_type
rate_obj_type
offering_obj_type

However, when pin_rel is run on the rated event file, it is observed that its updating the poid_type values which are not part of the above list of fields. i.e. it seems that the update is performed at record level for all records of rated event file. This way it impacts the poid_type values stored in any of other OOB fields or for any customization if we are holding any of the poid_type value in any field other than virtual column candidate fields, then we are losing that value as part of replace all that is performed by pin_rel.

Eg: In OOB flow, the invoice_data field of event_t holds the item_poid_type value (example below)
@INTEGRATE#009876543211#000204165664##186.5#VOICE##

Also in the customization, one can store the item_poid_type information in the TAX_CODE field of event_bal_impacts (example below)
XX_STD_VAT|326826|/item/xx/usage/xx_0129 627661

In both of the cases, /item/xx/usage/xx_0129 is getting replaced with the ID value, losing the original value.

This is the issue experienced in pin_rel.

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