Getting ORA-01843 : Not a Valid Month Executing Ledger Load Procedure (Doc ID 184011.1)

Last updated on APRIL 25, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
This problem can occur on any platform.
Server-Based Ledger Load
Checked for relevance on 25-Apr-2009.

Symptoms

In Oracle Financial Services Applications (OFSA) 4.5, when you execute the Ledger Stat Load procedure from a SQL*Plus application on your PC, you receive the following error:

ORA-01843: not a valid month

Steps to replicate:

SQL> set serveroutput on
SQL> execute ofsa_util.ledger_stat_load;

ORA-01843: not a valid month

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