My Oracle Support Banner

Journal Import fails with ORA-01400: Cannot Insert Null Into ("Gl"."Gl_je_segment_values"."Segm" after Consolidation (Doc ID 733641.1)

Last updated on MARCH 12, 2025

Applies to:

Oracle General Ledger - Version 12.0.5 and later
Information in this document applies to any platform.
EXECUTABLE:GLLEZL - Journal Import


Symptoms

Journal import from consolidation fails with the following message in the log file:

ERROR
Error in: gllisv
Function warning number: -1
ORA-01400: cannot insert NULL into ("GL"."GL_JE_SEGMENT_VALUES"."SEGME

STEPS TO REPRODUCE
1. General Ledger responsibility > Consolidation > Consolidation
2. Run journal import

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


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