EBS Customizations (MOSC)

MOSC Banner

User preference date format conflicts with concurrent program default date format

edited Feb 9, 2013 4:10AM in EBS Customizations (MOSC) 2 commentsAnswered
Hi everyone,

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. :-)

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