My Oracle Support Banner

Error "GetSQL Bind number 6 greater than number of input parameters. (2,600)" in Attachments Store Keys page (Doc ID 2582351.1)

Last updated on JANUARY 29, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When adding store key with a date type field type in Attachments Store Keys page, the following PeopleCode error appears:

Error GetSQL Bind number 6 greater than number of input parameters. (2,600). PNM_HR_ATTACHMENTS.Attachment_UI.OnExecute Name:ExistAttachments PCPC:5471 Statement 93
Called from:PNM_DERIVED_HS.PNM_ATTACH_PB.FieldFormula Statement:19
During the binding of input values into the SQL statement, a bind number in the SQL statement was larger than the input parameters.


The issue can be reproduced at will with the following steps:
1. Set Up HCM > Common Definitions > Attachments > Configure Keys >Configure Keys
2. Click on Attachments Store Keys page to enter store key values.
4. Add a Store key record with a date type field
5. Click OK.


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.