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

Last updated on AUGUST 02, 2023

Applies to:

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#<CELL NO>#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)
<CUST>_STD_VAT|326826|/item/<CUST>/usage/<CUST>_0129 627661

In both of the cases, /item/<CUST>/usage/<CUST>_0129 is getting replaced with the ID value, losing the original value.

This is the issue experienced in pin_rel.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.