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

Date Parameter Failure: ORA-01843

Avatar photoCustomer October 23, 2025 at 11:10 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support October 24, 2025 at 2:49 pm  

      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 October 26, 2025 at 8:17 am  

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

    • Support October 27, 2025 at 10:06 am  

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: