Unable to Use "Group By" Clause In the Select Statement Of PCM_OP_SEARCH With Sum() Function (Doc ID 1267132.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Dec-2012***
***Checked for relevance on 12-April-2015***

Symptoms

Using "group by" clause in PCM_OP_SEARCH results in PIN_ERR_STREAM_EOF.

Steps to Reproduce the Problem

Below is the search opcode flist with group by. When replaced F3 in the select statement with event_tax_jurisdictions_t.type, got the same result. (PIN_ERR_STREAM_EOF).

Search Flist (No Result flist added to search flist below since adding result flist causes a dm error indicating it should not be used with "group by"):

r << XXX 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 1
0 PIN_FLD_TEMPLATE STR [0] "select sum ( F1 ) from /event/billing/cycle/tax where F2 = V2 group by F3 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1   PIN_FLD_TAX_JURISDICTIONS ARRAY [0] allocated 20, used 1
2     PIN_FLD_AMOUNT DECIMAL [0] 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1   PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/cycle/tax 653597 1
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1   PIN_FLD_TAX_JURISDICTIONS ARRAY [0] allocated 20, used 1
2     PIN_FLD_TYPE ENUM [0] 0
XXX
xop PCM_OP_SEARCH 1 1



Search Output:

xop: opcode 7, flags 1
XOP "7" failed: err 50:PIN_ERR_STREAM_EOF, field 0/0:0,
loc 2:PIN_ERRLOC_PCP, errclass 3:PIN_ERRCLASS_SYSTEM_RETRYABLE, rec_id 0, resvd 0 # number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /error_poid -1 0
0 PIN_FLD_ERR_BUF ERR [0]
   <location=PIN_ERRLOC_PCP:2 class=PIN_ERRCLASS_SYSTEM_RETRYABLE:3 errno=PIN_ERR_STREAM_EOF:50>
   <field num=0:0,0 rec



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