What is the Significance of Using GB_QRY_LINK_VW in Group Build?
(Doc ID 1549697.1)
Last updated on NOVEMBER 02, 2022
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.
Group Build works fine without GB_QRY_LINK_VW.
In PeopleBooks "PeopleSoft HCM 9.1 Application Fundamentals PeopleBook" navigation "Home > PeopleBooks > PeopleSoft HCM 9.1 Application Fundamentals PeopleBook > Setting Up and Working with Group Definitions," it states:
When you define a query to use in group definitions, the following rules apply:
The first record you insert into the query must be the Group Build view (GB_QRY_LINK_VW).
The system uses this view to merge SQL statements that are created in the Group Build pages with the SQL statements that are created by PeopleSoft Query.
However, it seems that Group Build work fine if this view is excluded, as long as JOB record is part of the query definition. What is the significance of using GB_QRY_LINK_VW and what negative interactions might result in using JOB and not this GB view?
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