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:

Symptoms

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.
  

  
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
Menu Name - MANAGE_ASSETS
Market - GBL
Component - BASIC
Page - ASSET_GENERAL_01
Menu Action - Update

9. Hit "Map Columns"

10. Under "Map URL to Query Columns" select
A.BUSINESS_UNIT
A.ASSET_ID

11. Expression Text:
'psp/EMPLOYEE/E92ANTON/c/MANAGE_ASSETS.BASIC.GBL?Page=ASSET_GENERAL_01&Action=
U:A.BUSINESS_UNIT:A.ASSET_ID'

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

Cause

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