My Oracle Support Banner

ORA-00937 on Pct Distribution Allocation with Expression (Doc ID 1369426.1)

Last updated on OCTOBER 20, 2011

Applies to:

Oracle Financial Services Profitability Management - Version: 5.6 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run a Percent Distribution Allocation from Ledger to Instrument using Expression in Instrument as the driver the following error occurs in FSI_MESSAGE_LOG.

Error:
Oracle Error: ORA-00937: not a single-group group function
(908001) Fatal error during processing.


Steps:
1. Create a dynamic driver allocation with Ledger as the Source.
    Driver is additions of three Instrument table columns.
    Output is a different column of the Instrument table.
2. Run the allocation and see error in the view log.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

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