E-PIA: Configurable Search Throwing "SQL error in Exec. (2,280)..." When More than 254 Characters are Entered in the Business Unit Field Using "IN" Operator (Doc ID 2986981.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

Configurable Search Page is throwing below error when more then 254 characters are entered in the Business Unit field using IN operator.

Error:
-----
SQL error in Exec. (2,280) PTS_CFG_CL_WRK.PTS_SRCH_BTN.FieldFormula Name:AddToRecentSearches PCPC:53335 Statement:916
Called from:PTS_CFGSRCH_CL.StandardSearch.OnExecute Name:RunSearch Statement:144
Called from:PTS_CFG_CL_WRK.PTS_SRCH_BTN.FieldChange Statement: 107
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

This issue can be replicated using below steps:

1. Navigate to General Ledger -> Journals -> Journal Entry -> Create/Update Journal Entries.
2. Enter the Business Units in the Business Unit field by selecting the "IN" operator. If the character limit is more than 254 characters it throws SQL error.

(For Example:BUY06,BUY05,BUY04,BUY03,BUY02,BUY01,BLGE1,BLG01,ADB01,AUS01,BUY07,BUY08,CAN01,CAN02,CHE01,CN001,CZ001,DEU01,DEUE1,EGNBU,EGUBU,EGV01,EGV02,EGV03,EGV04,EGV05,

EGV06,EGVL1,EGVLE,ELIM1,ELIM2,ELIM3,ELIM4,ELIM5,ELIM6,ELIM7,ELIM8,ELIM9,ELM10,ELM11,ELM12,ELM13 )

Sample Environment:
--------------------

PT: 8.60.09
Application : FSCM 9.2 Image 48

Changes

 Upgrade to 8.60 Tools.

Cause

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