Enhancement Request for PCM_OP_SEARCH to Support Select of Aggregate Functions and Individual Fields (Doc ID 2680712.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Goal

Currently, Billing and Revenue Management (BRM) supports only aggregate functions (sum, count, max, min) in the select list of the PIN_FLD_TEMPLATE with group by clause in PCM_OP_SEARCH. Any
individual field in the select list is not supported.

For example: To fetch the open cycle charges from event object group by product object for a given account, the following input flist will not return the correct product POID in the output.

This is an enhancement request for the PCM_OP_SEARCH to support aggregate functions (sum, count, max, min) and individual field in the select list of the PIN_FLD_TEMPLATE with group by clause.
 

Solution

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