Home › Discussions › Questions & Answers › Date Parameter Failure: ORA-01843

Date Parameter Failure: ORA-01843

Avatar photoCustomer Questions & Answers 3 replies

After we changed the Oracle profile option ‘ICX: Date format mask’ away from the default ‘DD-MON-RR’, any Blitz Report using date parameters now fails with ORA-01843: not a valid month. Is this a known incompatibility?

3 replies

  • Support Enginatics

    Yes, this specific behavior is a known Oracle issue related to the inconsistency in the FND_DATE output mask when it deviates from ‘DD-MON-RR’. You are likely missing Oracle patch 12678526, which addresses this FND_DATE output format inconsistency.

  • Avatar photoCustomer

    Is there a workaround we can use until we schedule the application of that patch?

  • Support Enginatics

    The underlying problem is within Oracle’s FND date handling. The quickest temporary solution is to revert the ‘ICX: Date format mask’ profile option back to ‘DD-MON-RR’ on the relevant user or responsibility level to allow reports to run successfully.

  • You must be logged in to reply to this post.