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

ORA-01843: not a valid month with Date Parameters

Avatar photoCustomer Questions & Answers 3 replies

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.

3 replies

  • Support Enginatics

    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.

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

  • Support Enginatics

    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.

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