My Oracle Support Banner

Get The Exact Item POID Type When Virtual Columns Are Enabled (Doc ID 1552328.1)

Last updated on FEBRUARY 19, 2019

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

Symptoms

On all versions of Oracle Communications Billing and Revenue Management (BRM) up to 7.5 PS5 (inclusive), when virtual columns are enabled, the POID type is stored as an integer value in PIN_FLD_INVOICE_DATA:

0 PIN_FLD_INVOICE_DATA    STR [0] "#<MSISDN>#<MSISDN>#00P#1.0#<USAGE CLASS>#00P#<1 100375 278044500432368533 0#410#420##3780#258|1 100379 278044500432368534 0#410#418##6855#258|>"

Using PCM_OP_INV_DECODE_INVOICE_DATA to decode this string value, the output is as shown below:

xop: opcode 961, flags 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID           POID [0] 0.0.0.1 /invoice 1 0
0 PIN_FLD_EXTENDED_INFO SUBSTRUCT [0] allocated 20, used 8
1     PIN_FLD_CALLING_NUMBER    STR [0] "<MSISDN>"
1     PIN_FLD_CALLED_NUMBER    STR [0] "<MSISDN>"
1     PIN_FLD_SVC_CODE        STR [0] "00P"
1     PIN_FLD_NUMBER_OF_UNITS    INT [0] 1
1     PIN_FLD_USAGE_CLASS     STR [0] "<USAGE CLASS>"
1     PIN_FLD_DNIS            STR [0] "00P"
1     PIN_FLD_BAL_IMPACTS   ARRAY [0] allocated 20, used 6
2         PIN_FLD_ITEM_OBJ       POID [0] 0.0.0.1  100375 2147483647
2         PIN_FLD_RESOURCE_ID     INT [0] 410
2         PIN_FLD_QUANTITY     DECIMAL [0] 420
2         PIN_FLD_RATE_TAG        STR [0] ""
2         PIN_FLD_AMOUNT       DECIMAL [0] 3780
2         PIN_FLD_IMPACT_TYPE    ENUM [0] 258
1     PIN_FLD_BAL_IMPACTS   ARRAY [1] allocated 20, used 6
2         PIN_FLD_ITEM_OBJ       POID [0] 0.0.0.1  100379 2147483647
2         PIN_FLD_RESOURCE_ID     INT [0] 410
2         PIN_FLD_QUANTITY     DECIMAL [0] 418
2         PIN_FLD_RATE_TAG        STR [0] ""
2         PIN_FLD_AMOUNT       DECIMAL [0] 6855
2         PIN_FLD_IMPACT_TYPE    ENUM [0] 258

To find the exact item POID type it is possible search DD_OBJECTS_T, but can this be solved like a function that can be called in the opcode to decode the number to POID type or other table?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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