EGL9.2:KK_WRK.SEARCH_BUTTON.FieldChange &efdt Date Values Always Invalid.
(Doc ID 2901539.1)
Last updated on OCTOBER 10, 2022
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Budget Definition - Control Chartfield not showing data, even if they put criteria and search.
KK_WRK.SEARCH_BUTTON.FieldChange &efdt date values always invalid
The ruleset PeopleCode is always in an invalid format because the SQL is being built in hardcoded string without regard to the database type or database date time format.
&efdt = &rsRuleset.GetRow(&j).GetRecord(Record.KK_BD_SETID).GetField(Field.EFFDT).Value;
&sqlStr = &sqlStr | " and EFFDT='" | &efdt | "' ";
In customer's instance, this resolves with EFFDT='2021-07-01'
This is not correct as their database format is DD-MON-YY. It should instead resolve to EFFDT=TO_DATE('2021-07-01','YYYY-MM-DD')
Steps to replicate:
1. Navigate to Commitment Control > Define Control Budgets > Budget Definitions.
2. Open: SetID and Ledger Group
3. Click Control Chartfield tab, populate criteria and click Search.
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