My Oracle Support Banner

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

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