Group By Clause Not Working In PCM_OP_SEARCH With Sum() Function. (Doc ID 959273.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 21-May-2013 ***

Symptoms

Problem Statement
Group By clause is not working in PCM_OP_SEARCH with sum() function.

Steps To Reproduce

1.Create an flist as follows:

0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 255
0 PIN_FLD_TEMPLATE STR [0] "select sum( F5 ), sum ( F8 ) from /event 1, /item 2 where 2.F1 = 1.F2 and 1.F3 = V3 and 2.F4 = V4 and 1.F6 in ( V6 , 'WEEKOFF' ) and 1.F7 = V7 group by event_t.item_obj_id0 "
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 2
1 PIN_FLD_AMOUNT DECIMAL [1] NULL
1 PIN_FLD_AMOUNT DECIMAL [2] NULL
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_ITEM_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 2889416 0
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_BILL_OBJ POID [0] 0.0.0.1 /bill 2891208 0
0 PIN_FLD_ARGS ARRAY [5] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 1
2 PIN_FLD_AMOUNT_ORIG DECIMAL [0] 0
0 PIN_FLD_ARGS ARRAY [6] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 1
2 PIN_FLD_RATE_TAG STR [0] "WEEKEND"
0 PIN_FLD_ARGS ARRAY [7] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 1
2 PIN_FLD_IMPACT_TYPE ENUM [0] 258
0 PIN_FLD_ARGS ARRAY [8] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 1
2 PIN_FLD_AMOUNT DECIMAL [0] 0
0 PIN_FLD_ARGS ARRAY [9] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 1
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 2890696 0



2. Execute PCM_OP_SEARCH from testnap or Developer Center. Search is not working from testnap and Developer center. 

 

Cause

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 hundreds of Community platforms