My Oracle Support Banner

R12 Deleting Unposted Reversal Journal In Primary Ledger Deletes Posted Reversal Journal In Secondary Ledger (Doc ID 1500805.1)

Last updated on AUGUST 13, 2018

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLPPOS - Posting
Executable:GLPARV - Auto Reversal Program
Form:GLXJEENT.FMB - Enter Journals/Encumbrances

Symptoms

Create a manual journal entry in the Primary Ledger and post.
Posting the journal in the Primary Ledger automatically creates and posts the journal in the Secondary Ledger as per standard functionality.
Then reverse the original journal in the Primary Ledger (using the "Reverse botton" in the journal entry screen")
When reverse the Journal in the Primary Ledger, it automatically creates an "unposted" Reversal journal for both Primary and Secondary Ledgers as per standard functionality.
Run the Auto reverse program in the Secondary Ledger only.
The reversal journal is still unposted in the Primary Ledger but posted in the Secondary Ledger only as Auto reverse was run only in the Secondary Ledger
Delete the reversal  journal in the Primary ledger, which is still in an unposted status, via the Journal /enter form.
It deleted both the Primary Ledger reversal journal and also the Secondary Ledger reversal journal which is posted (NOT CORRECT) which causes a balance mismatch between journal and balances.

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.