My Oracle Support Banner

EGL 9.2: Pivot Grid Viewer Errors With Generic Error While Executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:ExecuteDrillDn PCPC:128331 Statement:2067 When Pulling Up PC_PROJ_FINANCIALS_FL (Doc ID 2567626.1)

Last updated on DECEMBER 22, 2020

Applies to:

PeopleSoft Enterprise FIN Financials Portal Pack - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE
---------------
When trying  to pull up the pivot grid PC_PROJ_FINANCIALS_FL an error is received

ERROR
---------------
Generic error while executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:ExecuteDrillDn PCPC:128331 Statement:2067
Called from:PTPG_API.Execution.OnExecute Name:ExecuteDrillDown Statement:326
Called from:PTPG_API.Model.OnExecute Name:getDetailView Statement:422
Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:GetSearchResults Statement:972
Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:populateSearchGrid Statement:134
Called from:PTS_SEARCH.Pi (0,

STEPS
---------------
1) Go to Reporting Tools -> Pivot Grid - Pivot Grid Viewer
2) Enter pivot grid and clicked ON Show All Views (clicked on search)
3) 1 row returned for Pivot Grid Name PC_PROJ_FINANCIALS_FL
4) Click on the Pivot Grid Name - note error

Cause

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
Symptoms
Cause
Solution
References


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