23021390 ORA-00979: Not A GROUP BY Expression ORA-06512: At "DP.PARALLEL_MANAGER", Line202 ORA-06512 (Doc ID 2176448.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Technical

When attempting to run the GL synchronization process having the standard values in series_synch table,
the following error occurs.

ERROR
-----------------------
2016-03-12 21:39:19,347 CET [WFProcess_26] FATAL workflow.general: ORA-00979: not a GROUP BY expression ORA-06512: at "DP.PARALLEL_MANAGER", line 202 ORA-06512: at "DP.PARALLEL_MANAGER", line 71 ORA-06512: at "DP.SYNCH", line 70 ORA-06512: at
line 1 java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression ORA-06512: at "DP.PARALLEL_MANAGER", line 202 ORA-06512: at
"DP.PARALLEL_MANAGER", line 71 ORA-06512: at "DP.SYNCH", line 70 ORA-06512:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Workflow Manager.
2. Run IMI Test - GL Sync workflow that execute synch.run_batch(2,1,1) .
3. It fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the GL synchronization . Customer is having end to end testing lined up on Monday (14-March-16) and without this issue fixed, customer will miss this deadline which will impact the go-live dates.

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