My Oracle Support Banner

EGL9.1 - 9.2: Spreadsheet Journal Import(JRNL1) Adds Lines To Valid Journal But Doesn't Change Header Status Causing Various Data Integrity Problems (Doc ID 1911412.1)

Last updated on MARCH 25, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for Currency -24-MARCH-2016****

Symptoms

 
Issue:
-------

Spreadsheet Journal Import allows a user to upload additional lines to a valid journal (JRNL_HDR_STATUS = 'V'). When this happens the journal can get posted without being edited again since the additional line does not update the header status (or timestamp).


Steps To Replicate:
-----------------------
The issue can be reproduced at will with the following steps:
1. Add 4 lines – 2 lines for each business unit US001 and US005
2. Edit, mark to post but do not post.
3. Add another journal with same journal_id /date, but with different business unit us007
5. Click on Upload Now button.

Actual Behavior:
------------------

Pop up says it does not upload the journal with same journal id/date, but the process does add a line to us005. Also the journal header status is not changed back from 'V' to 'N'.

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.