E-QR: Query With Attachment Drilldown URL Fails With The Error:"Invalid parameter 1 for function CreateRowset. (2,116) PTFILE_HTTP.Utils.OnExecute Name:ValidateRequest PCPC:935 Statement:29 Called from:WEBLIB_FILEHTTP.ISCRIPT1.FieldFormula Name:IScript" (Doc ID 2089158.1)

Last updated on MARCH 20, 2017

Applies to:

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

Symptoms

When attempting to run PS Queries with Drilling URLs the following error occurs:

"Invalid parameter 1 for function CreateRowset. (2,116) PTFILE_HTTP.Utils.OnExecute Name:ValidateRequest PCPC:935 Statement:29
Called from:WEBLIB_FILEHTTP.ISCRIPT1.FieldFormula Name:IScript_GetAttachment Statement:16"

Steps
---------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Use the navigation: Reporting Tools > Query > Query Manager
3. Create a new PS_Query (SB_TEST_DRILLDOWN)
4. View Query SQL:
SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, B.BUSINESS_UNIT, B.VOUCHER_ID,
C.SCM_ATTACH_ID, C.ATT_VERSION, C.ATTACHUSERFILE
  FROM PS_VOUCHER A,
PS_AP_VCHR_ATT B, PS_PV_ATTACHMENTS C
  WHERE ( A.BUSINESS_UNIT =
B.BUSINESS_UNIT
  AND A.VOUCHER_ID = B.VOUCHER_ID
  AND
B.SCM_ATTACH_ID = C.SCM_ATTACH_ID
  AND B.ATT_VERSION = C.ATT_VERSION

  AND A.BUSINESS_UNIT_GL = 'US001'
  AND A.VOUCHER_ID = '00000111' )

5. Go to Expression tab

6. Create a new expression as using 'Drilling URL' type

7. Click on 'Attachment URL ' hyperlink

8. Add the URL ID: PS_PV_ATTACHMENTS that was created as follows:
  8.1. Navigate to PeopleTools > Utilities > Administration > URLs
  8.2 Add a new Url -
URL Identifier: PV_ATTACHMENTS
*Description: PV_ATTACHMENTS
*URLID: record://PS_PV_ATT_DB_SRV

9. Click on Map Fields and select the C.ATTACHUSERFILE

10. Go to Run tab

11. Click on the URL in the 'Attachment' field:

12. Received the error

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