Error “ORA-00979: not a GROUP BY expression” When Importing with Logic Groups in FDM

Error “ORA-00979: not a GROUP BY expression” When Importing with Logic Groups in FDM

		Modified 23-NOV-2010     Type PROBLEM

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.3.00<max_ver> and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Receiving error “ORA-00979: not a GROUP BY expression” when importing data in FDM on a location with Logic Groups attached.
The logic is complex and using the Group By option on one account.

Cause

This is related to unpublished bug 9223586 on Oracle Databases.
It is caused by having the 'cursor_sharing' initialization parameter set to "similar" and not "exact".

Solution

A) Update the "Cursor Sharing" Initialization Parameter on the Oracle Database Instance from the current setting of "Similar" to "Exact"

B) Restart the Database Instance following the Change.

References

BUG:9223586 - ORA-979 FROM QUERY USING TO_NCHAR WITH UTF8 NCHARACTERSET