My Oracle Support Banner

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.

Goal

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:

Use PeopleSoft Query with Group Build to define a group to access many more tables than the thirty-two tables that are available on the Group Criteria page or the Group Definition page.

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?
 

Solution

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
Goal
Solution


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