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 MAY 01, 2017

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

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