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

Last updated on DECEMBER 21, 2015

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.

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