My Oracle Support Banner

Error " ORA-01843: not a valid month " In The Flash Sale Report (Doc ID 2434662.1)

Last updated on AUGUST 03, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Getting below error while running the Flash Sale Report:

"
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLDataException: ORA-01843: not a valid month ORA-06512: at line 3

"

Steps To Reproduce:
1. Login to BI Publisher using language anything apart from English Language.
2. Click on Catalog.
3. Go to RMS>Sales Audit>SAFSSTR.
4. Click Open >Enter the Business Date.
5. Not the above error.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.