My Oracle Support Banner

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

Last updated on SEPTEMBER 24, 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

Symptoms

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] "@INTEGRATE#001030371057#01093988929#00P#1.0#WRVOR#00P#<1 100375 278044500432368533 0#410#420##3780#258|1 100379 278044500432368534 0#410#418##6855#258|>"

If one use 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] "001030371057"
1     PIN_FLD_CALLED_NUMBER    STR [0] "01093988929"
1     PIN_FLD_SVC_CODE        STR [0] "00P"
1     PIN_FLD_NUMBER_OF_UNITS    INT [0] 1
1     PIN_FLD_USAGE_CLASS     STR [0] "WRVOR"
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
 
If one need to find the exact item POID type. One method is you can search from 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!


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