My Oracle Support Banner

Journal Header And Lines Have Different GL Period And Date (Doc ID 405261.1)

Last updated on JANUARY 30, 2024

Applies to:

Oracle General Ledger - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


Several journals were created on 01-DEC-20 for NOV-20 period. The headers have an effective date of 30-NOV-20 and the period name is NOV-20. The lines have a default effective date of 01-DEC-20 and period name DEC-20. The journal source is MANUAL.

The balances are updated in December there is no balances available in NOV-20 and drilling down on an account combination in the journal in DEC-20 shows the total for the journals does not add up to the balances

The expectation is that the dates on the header and lines are the same.


This will also show up if you run glbalfix datafix in report mode as:

Error 18: The posted status or period for one of your lines doesn't match the in formation at batch or journal level.
Balance corruption fix program aborted.




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

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