Getting Error 'ORA-01843: Not a Valid Month' Running a SQL Rule
(Doc ID 1584622.1)
Last updated on AUGUST 25, 2020
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 to 7.3.2 [Release 7]Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 7.3.2
Symptoms
In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3.2, when you run a SQL Rule to update rows that includes SQL with a "where" condition on a date column (ex. AS_OF_DATE), the SQL Rule fails with the following error in the View Log:
ORA-01843: not a valid month
The SQL Rule contains a date like '03/31/2013' and the Oracle Database has the NLS_DATE_FORMAT set to 'mm/dd/yyyy'. The same SQL statement executes successfully in SQL*Plus/SQL Developer. You expect the SQL Statement to execute successfully in the SQL Rule also.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |