CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Issue with DFF Default Value Not Reflecting Hijri Date on Employment Page

Dears,

We are implementing a requirement from our client to display the current date in Hijri calendar format on the Employment page using a Descriptive Flexfield (DFF).

We have already created the DFF and configured the default value using the following SQL expression:

sqlCopyEditSELECT TO_DATE(         TO_CHAR(SYSDATE, 'DD MM YYYY', 'NLS_CALENDAR = ''English Hijrah'''),         'DD MM YYYY'       ) FROM DUAL

However, the field on the Employment page does not reflect any value — it appears empty.

We have:

  • Cleared application caches,
  • Tried multiple browsers and sessions,
  • Tested variations of the query.

Despite these efforts, the Hijri date still does not appear in the DFF.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center