How to Display Hijri Date as Default Value in DFF on Employment Page? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Display Hijri Date as Default Value in DFF 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!