My Oracle Support Banner

Group Build - Group Definition Not Working With Query Containing An Expression: "Fatal SQL error occurred. (2,125) GB_EXEC_LIB.GB_EXEC.GBL.default.1900-01-01.Step05.OnExecute" (Doc ID 1539080.1)

Last updated on FEBRUARY 07, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise HCM ePerformance - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Group Build - Group Definition Not Working with PSQuery Containing an Expression

STEPS TO REPLICATE
--------------------
1. Navigate to Set Up HRMS > Common Definitions > Group Build > Group Build - Definition
2. Create a new Group Build Definition.
3. Enter simple criteria on the Group Definition page such as JOB.DEPTID = 1000.
4. Save the page.
5. Click either the  'Launch Count' or 'Visualization' icon.  Error is displayed.

ERROR
----------------
"A fatal PeopleCode SQL error has occurred.  Please consult your system log for details."
"Fatal SQL error occurred. (2,125) GB_EXEC_LIB.GB_EXEC.GBL.default.1900-01-01.Step05.OnExecute"

BUSINESS IMPACT
-------------------
Unable to use Group Build function

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.