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

Last updated on SEPTEMBER 24, 2018

Applies to:

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

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