Home Discussions Questions & Answers ORA-01843: not a valid month with Date Parameters

ORA-01843: not a valid month with Date Parameters

Avatar photoCustomer August 5, 2020 at 2:22 pm

After changing the Oracle profile option ICX: Date format mask from DD-MON-RR to something else, reports using date parameters now fail with ORA-01843: not a valid month.

Viewing 2 reply threads
  • Author
    Replies
    • Support August 6, 2020 at 3:32 pm  

      This is a recognized inconsistency in date output mask handling when moving away from the default format. The most likely cause is that you are missing Oracle patch 12678526.

    • Avatar photoCustomer August 7, 2020 at 7:03 pm  

      Is there any temporary solution while we plan the patch application?

    • Support August 9, 2020 at 5:14 pm  

      The underlying issue relates to the consistency of FND_DATE output. Temporarily reverting the ICX: Date format mask profile option back to DD-MON-RR on the relevant responsibility or user level should allow the reports to run again.

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

Login with: