GLPREV Journal Reversal Completes With Errors ORA-01400: cannot insert null into ("GL"."GL_JE_BATCHES"."DEFAULT_EFFECTIVE_DATE") (Doc ID 1916102.1)

Last updated on APRIL 08, 2016

Applies to:

Oracle General Ledger - Version 12.2.3 and later
Information in this document applies to any platform.
Executable:GLPREV - Reverse Journals

Symptoms

When attempting to reverse a journal, the following errors are generated in the request log file:

ERROR
-----------------------
Oracle database error trapped at function: GLPRIB_label: glprib_error
ORA-01400: cannot insert null into ("GL"."GL_JE_BATCHES"."DEFAULT_EFFECTIVE_DATE")

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate > Journal Enter
2. Query back Journal to be reversed
3. Click Reverse button
4. ‘Reverse Journals’ concurrent ends with error ORA-01400: cannot insert null into ("GL"."GL_JE_BATCHES"."DEFAULT_EFFECTIVE_DATE")

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