My Oracle Support Banner

Group Build Using PSQuery Does Not Produce The Same Count As The PSQuery Outside Of Group Build (Doc ID 2601300.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

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


When using a PSQuery to fetch employees in Group Build, the count returned does not match the count of employees returned by the PSQuery.

The issue can be replicated as follows:

  1. Create a PSQuery in Query Manager and review result count.  Navigation: Reporting Tools > Query > Query Manager
  2. Use this same PSQuery in a Group Build Definition. Navigation: Set Up HCM > Common Definitions > Group Build
  3. Click on the icon on the Group Build Definition page to show the count result.
  4. Notice the count from the PSQuery does not match the count result in the Group Build Definition.




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

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