My Oracle Support Banner

GLXJEENT: Journal Header Totals Do Not Match the Journal Lines Totals (Doc ID 121014.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle General Ledger - Version 10.7.16.1 to 11.5.10.2 [Release 10.7 to 11.5.10]
Information in this document applies to any platform.
Form:GLXJEENT.FMB - Enter Journals/Encumbrances


Symptoms

When you enter journal lines, there is a difference between the total credit/debit amount in the journal header and the sum of credit/debit amount in the lines.
This problems occurs randomly. You have not identified special conditions when this happens.

Useful Queries:

Using these SQL queries, you can verify that the Journal is balanced for debit/credit amounts in its lines, but this total is not the same stored in the header.

1. Obtain the value for header_id in Journal Entry form, by using the menu Help > Tools > Examine in the Journal Header.
If a password is required, ask your System Administrator.
Find the value for JE_BATCH_ID and JE_HEADER_ID in HEADER block.

Alternative, you may use the following SQL:

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!


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