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.
Tagged:
0