E-FLUID/E-PIA : Clicking On the "Edit Search" Link Of a Saved Journal Search Returns An "assignment of "YYYY-MM-DD1,YYYY-MM-DD2" to JRNL_HDR_IU_VW.JOURNAL_DATE failed. (2,119)..." PeopleCode/SQL Error
(Doc ID 2983162.1)
Last updated on JUNE 04, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.60 to 8.60 [Release 8.4]Information in this document applies to any platform.
Symptoms
Clicking on the "Edit Search" Link of a saved journal search returns the following PeopleCode error, and a SQL error message is displayed on PIA
Error:
assignment of "2023-09-19,2023-10-19" to JRNL_HDR_IU_VW.JOURNAL_DATE failed. (2,119)
PTS_CFGSRCH_FL.Utilities.OnExecute name:GetTranslateValue PCPC:5720 Statement:93
Called from:PTS_CFG_CL_WRK.PTS_SRCH_BTN.FieldFormula Name:DisplaySavedSearchResults
Statement:1981
Called from:PTS_SAVESRCHCL_SEC.Activate Statement:3
Steps to replicate:
1. Log into PIA, and navigate to the Journal Entry Page (Navigation: General Ledger > Journals > Create/Update Journal Entries).
2. Enter a journal date between From/To Dates, click on "Search", and then click on "Save Search".
3. Click on "Edit Search", and observe the errors above.
Sample Environment:
PeopleTools (PT) 8.60.08
FSCM 9.20
Changes
Upgraded to PeopleTools 8.60.08
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |