My Oracle Support Banner

EGL9.2: Modifying Manage Saved Search in Create/Update Journal Entries - Find an Existing Value Page Results to Error -- 'Assignment of "2023-10-01,2023-10-31" to JRNL_HDR_IU_VW.JOURNAL_DATE failed' (Doc ID 3019363.1)

Last updated on APRIL 29, 2024

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


When modifying saved searches by clicking Manage Saved Search in Create/Update Journal Entries - Find an Existing Value Page, this results to error.
For the scenario, make multiple saved searches, where one of which use range of values (i.e. Journal Date between yyyy-mm-dd and yyyy-mm-dd).

Steps to replicate:

1.  Create multiple Saved Searches in JOURNAL_ENTRY_IE component. (General Ledger > Journals > Journal Entry > Create/Update Journal Entries)
2.  Go to Find an Existing Value page, and access Manage Saved Searches.
3.  Choose a new 'Display By' option and select Save, error is received.


Assignment of "yyyy-mm-dd,yyyy-mm-dd" to JRNL_HDR_IU_VW.JOURNAL_DATE failed. (2,119) PTS_CFGSRCH_FL.Utilities.OnExecute Name:GetTranslateValue PCPC:5720 Statement:93
Called from:PTS_SAVESRCH_MG.PTS_DISP_SAVEDSRCH.FieldFormula Name:DisplaySavedSearchResults Statement:85
Called from:PTS_SAVESRCH_MG.PTS_DISP_SAVEDSRCH.FieldChange Statement:3

The assignment to the specified field failed.

The failure can be caused by any one of several problems. The new value could be too long to fit into the field, the new value could have too many digits (possibly including a sign) to the left of the decimal point to fit into the numeric field, there could be problems converting the new value to internal format, the field might not be present in the page buffers (rare), or there could be a memory allocation error (very rare).

Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed. A trace including "Show Assignments to Variables" will trace the new value.




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.