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
# 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 |