Getting Error 'ORA-01843: Not a Valid Month' Running a SQL Rule (Doc ID 1584622.1)

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

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

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