My Oracle Support Banner

HowTo Include Joined Fields in PIN_FLD_RESULTS for PCM_OP_SEARCH (Doc ID 1104265.1)

Last updated on AUGUST 27, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

How to get both fields in the base table and joined table by single PCM_OP_SEARCH command?

The input flist does not work:

0 PIN_FLD_POID POID [0] 0.0.0.1 /search 1 0
0 PIN_FLD_FLAGS INT [0] 512
0 PIN_FLD_OP_CORRELATION_ID STR [0] "1:dev:UnknownProgramName:0:AWT-EventQueue-0:7:1273826390:0"
0 PIN_FLD_TEMPLATE STR [0] "select X from /plan 1, /purchased_product 2 where ( 1.F1 = 2.F2 ) and 2.F4 = V4 and 2.F3 = V3 "
0 PIN_FLD_RESULTS ARRAY [*] allocated 1, used 1
1     PIN_FLD_NAME STR [0] NULL
0 PIN_FLD_ARGS ARRAY [1] allocated 1, used 1
1     PIN_FLD_POID POID [0] 0.0.0.0 / 0 0
0 PIN_FLD_ARGS ARRAY [2] allocated 1, used 1
1     PIN_FLD_PLAN_OBJ POID [0] 0.0.0.0 / 0 0
0 PIN_FLD_ARGS ARRAY [3] allocated 1, used 1
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1231687 0
0 PIN_FLD_ARGS ARRAY [4] allocated 1, used 1
1     PIN_FLD_STATUS ENUM [0] 1


The output flist has no value of PIN_FLD_STATUS from /purchased_product:

0 PIN_FLD_POID POID [0] 0.0.0.1 /search 1 0
0 PIN_FLD_OP_CORRELATION_ID STR [0] "1:dev:UnknownProgramName:0:AWT-EventQueue-0:7:1273826390:0"
0 PIN_FLD_RESULTS ARRAY [0] allocated 2, used 2
1     PIN_FLD_POID POID [0] 0.0.0.1 /plan 247229 0
1     PIN_FLD_NAME STR [0] "GSM_Pipeline"
0 PIN_FLD_RESULTS ARRAY [1] allocated 2, used 2
1     PIN_FLD_POID POID [0] 0.0.0.1 /plan 247229 0
1     PIN_FLD_NAME STR [0] "GSM_Pipeline"
 

 

Solution

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
Goal
Solution


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