User preference date format conflicts with concurrent program default date format
We have an issue with user preference date formats (which could be any of several date formats defined in the User Preferences > General) conflicting with the date format of the defaulted date in a report parameter. The message is:
Please enter date value 01/01/2013 in correct format: DD-MON-RRRR
That part is resolved by deriving the date using the following SQL:
select to_char(trunc(sysdate,'YEAR'),fnd_profile.value('ICX_DATE_FORMAT_MASK')) from dual
Any suggestions on how to take the newly formatted date and convert it to the format needed by the report (DD-MON-RRRR) without opening the report? That may sound like a longshot, but there are some pretty creative people out there in Oracle land. :-)