My Oracle Support Banner

Error Reversing Journal: ORA-01840: 'Input Value Not Long Enough For Date Format' (Doc ID 2263342.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to reverse journals either by "Program - Automatic Reversal" or "Reverse Journals" process, both are failing with an Oracle date format error for a particular ledger.

ERROR
-----------------------
Secondary ledger and primary ledger accounting calendar are different.
Actual balance journal.

ORA-01840: input value not long enough for date format

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Reverse journals either by "Program - Automatic Reversal" or "Reverse Journals"


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


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