Issue With Pin_rel Behavior With Virtual Columns Feature
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.5.0]
***Checked for relevance on 4-May-2015***
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 :
columns virtualized under event_bal_impacts are :
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)
Also in the customization, one can store the item_poid_type information in the TAX_CODE field of event_bal_impacts (example below)
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.
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