Getting Error 'ORA-01843: Not a Valid Month' Running a SQL Rule
Last updated on JANUARY 04, 2017
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms