EGL9.2: Journal Unposting Set Reversal Journal, Which Was Never Posted Before, in 'D' (Deleted) status and Reversal Unposting Entry in 'P' (Posted), Causing Ledger Imbalance. (Doc ID 1904702.1)

Last updated on MAY 04, 2023

Applies to:

Symptoms

Issue:
-------

Unposting reversing journals creates imbalance in ledger  

Only current period is open. Below are not checked on Ledger For A Unit > Journal Post Options
- Do not Post Future-dated Jrnls
- Automatic Post Reversals

Actual Behavior:
------------------
Reversing journal is created and posted in current period with reversal created in 'V' status for next Period.
The business decided to unpost this journal with reversal.
After marking this journal for unpost, running batch journal post without specifying journal id and date results in this journal having below headers status.
Ledger is imbalanced for next period.

- Original jrnl Seq 0 Status U and posted to ledger
- Original jrnl Seq 1 Status P and posted to ledger – net result of zero in current period
- Reversal jrnl Seq 0 Status D and not posted to ledger
- Reversal jrnl Seq 1 Status P and posted to ledger – Result imbalance in next period

Open next period period and try to process again - Journals' status remains same and ledger remains out of balance.

Expected Behavior:
-------------------

Journal reversal and unposting entries should all hit ledger with correct header status:
- Original jrnl Seq 0 Status U and posted to ledger
- Original jrnl Seq 1 Status P and posted to ledger – net result of zero in current period
- Reversal jrnl Seq 0 Status D (Deleted) and not posted to ledger
- Reversal jrnl Seq 1 Status D (Deleted) and not posted to ledger  – net result of zero in next period.

What is Working:
-------------------
If running journal post from Marking Journal Unpost page with run control ID populated with journal ID and date, the journal reversal unposting entries are correctly marked as 'D' - Deleted ( because period is not open so reversal is not posted. When unpost is requested, both reversal and its unposting entry are marked as deleted. No impact on ledger balance.)

Steps to Replicate:
---------------------
1. Open current period only.
2. Ensure below is not checked on Ledger For A Unit > Journal Post Options.
   >> Do not Post Future-dated Jrnls
   >> Automatic Post Reversals
3. Create a journal with reversal at next period.
4. Edit and post journal so reversal created in 'V' status and original journal in 'P' ( posted)
5. Mark above journal for Unposting.
6. Run Batch Journal Post without specifying journal ID and Date to unpost above journal (original journal and reversal).
7. After unposting, review journal header status and ledger balance.

Changes

Cause

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