My Oracle Support Banner

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

Last updated on APRIL 17, 2018

Applies to:

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

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. 

 

Changes

 

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.