ORA-00937 Not a Single-Group Error During Allocation After PFT Solaris Patch 21671376 (Doc ID 2099798.1)

Last updated on MAY 06, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 to 6.1.0.3 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 6.1.0.3 version, Calculation Engine

When attempting to run a field allocation with expression that previously worked, the allocation engine failed with below error.


Error:
Error: ORA- 00937: not a single- group group function
Driver Function: drv_oci::Execute() SQL Statement:
MERGE INTO FSI_D_CONSUMER_LOAN TARGET USING (
SELECT IDENTITY_CODE, ID_NUMBER, SUM((NVL(a.TRANSFER_RATE, 0)* 2)
/ 36500 * NVL(CUR_NET_BOOK_BAL_C, 0) ) TARGET_AMOUNT
from FSI_D_CONSUMER_LOAN a
where a.as_of_date='11/ 14/ 2015' ) SOURCE ON
(SOURCE.IDENTITY_CODE = TARGET.IDENTITY_CODE
AND SOURCE.ID_NUMBER = TARGET.ID_NUMBER ) WHEN MATCHED THEN
UPDATE
SET IDENTITY_CODE_CHG = 14917.000000 , TARGET.CHARGE_CREDIT_TRATE
= (SOURCE.TARGET_AMOUNT * 1)

Steps:

1. Ran a field allocation with expression.

2. Applied Solaris patch 6.1.0.3.16 - Bug 21671376 PFT One-off Bug for ALM bug 21454660 Issue with the Performance of ALM 6.1

3. Ran the same allocation and it failed with the above error.

Changes

 Applied PFT Solaris Patch 21671376.

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