EGL9.1 - 9.2: Multiple BU Journal Showing JRNL_HDR_STATUS = 'P' (Posted) for Some Business Units But Relevant Journal Line Amounts Are not Posted to the Ledger

(Doc ID 2041893.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

Site has Batch journal post scheduled every 10 minutes while user is able to edit/post journal online at same time.

The problematic journal is uploaded via spreadsheet import with over 250 business units. There is no interunit transaction line b/w any of 2 business units.

After user running online edit and post on this journal, JRNL_HDR_STATUS is updated to 'P' (Posted) but journal amounts for some BUs are not reflected in the ledger.
It is found that 2 process instances accessed/updated this same journal, which has multiple BU/headers.

This issue leads to journal and ledger integrity concern.

Expected Behavior:
----------------------
Expect the complete journal amounts from this journal are updated on the ledger.

Steps to Replicate:
---------------------
The issue can be reproduced at will with the following steps:
1. Load multiple BU journal via import process.
2. Run Online Edit.
3. Run Online Post

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