My Oracle Support Banner

E-PG: Error "Called from:PTS_SEARCH.PivotGridSearch.OnExecute" Seen When Exporting Pivot Grid Filtered with Data Drilling URL To PDF (Doc ID 2862752.1)

Last updated on MAY 12, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.


Export pivot grid filtered data to PDF errors out when query source has drilling url.

The following error is generated when exporting the pivot grid filtered data to PDF from Query Viewer if the query source contains a drilling url.

"(No Msg): ExecuteForPDF
PTPG_API.Model.OnExecute Name:downloadToExcelFilteredData
Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:downloadToExcelFilteredData"

The issue can be reproduced at will with the following steps:
1. Navigation : Main Menu > Reporting Tools > Query > Query Manager >

2. PSQuery Data Source - AM_ACQ_BY_CATEGORY

3. "Edit" link.

4. "Expressions" tab

5. "Add Expression" button

6. Expression Type - Drilling URL

7. Hit "Component URL" link

8. Portal Name - EMPLOYEE
Node Name - E92ANTON
Market - GBL
Component - BASIC
Menu Action - Update

9. Hit "Map Columns"

10. Under "Map URL to Query Columns" select

11. Expression Text:

12. Save.

1. Navigation : Main Menu > Reporting Tools > Pivot Grid Wizard

2. Add a New Value

3. Pivot Grid Name - TEST_AM_ACQ_BY_CAT

4. Data Source Type - PS Query

5. Query Name - AM_ACQ_BY_CATEGORY

6. Select Query Prompt Values

7. *Business Unit - US001

8. *Book - CORP

9. Save

10. Step 5 of 5

11. Navigation : Main Menu > Reporting Tools > Pivot Grid Viewer

12. TEST_AM_ACQ_BY_CAT - Open in Fluid Mode

13. Options Menu

14. Export Filtered Data

15. As PDF


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.