Error Opening Job Opening Aging Analysis Pivot Grid in Recruiting Home: "Generic error while executing the Query datasource. (268,91)" (Doc ID 2047463.1)

Last updated on JANUARY 31, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Recruiting > Recruiting Home

Error 268,91 is returned when opening Job Opening Aging Analysis if more than one Status Code is marked as Open.

Error:
Generic error while executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:GetAllDimensionValues PCPC:68123 Statement:1215
Called from:PTPG_WORKREC.FUNCLIB.FieldFormula Name:ViewerPageActivate Statement:2225
Called from:PTPG_PGVIEWER.Activate Statement:1

Steps:
1. Go to Status and Reasons for Recruitment Area = 1-Job Opening.
2. Mark one of the Status Codes as Open.
3. Go to Recruiting Home.
4. In the My Job Openings section, click My Job Openings Analytics > Job Opening Aging Analysis.
5. Note that the error message is returned.

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