Fusion Global HR: Execution Error In Vanilla HCM Extract

(Doc ID 2230893.1)

Last updated on DECEMBER 17, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms


Execution Error in Vanilla HCM extract
An error has occurring when while running a copied or imported Vanilla Worker HCM Extract.

ERROR
-----------------------
ORA-00937: not a single-group group function

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Search for WorkerExtract in the Manage Extract Definitions
2) Click on copy button and entered with the name (WorkerExtract001)
3) Search for WorkerExtract001 extract and edit.
4) Compile all formulas and validate
5) Submit the extract.


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