My Oracle Support Banner

EGL9.2: Spreadsheet Journal Upload (JRN1_WS) Does Not Give Warning Message If Anchor BU Does Not Have Line Transaction (Doc ID 2480820.1)

Last updated on JULY 13, 2019

Applies to:

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


If you create an interunit spreadsheet journal where the header BU = A and line BU = B, spreadsheet journal does not warn that there are no lines for BU = A.

Note: If you do a journal online this way, it does warn you.

Below is the error you get when you do a journal online where the Header BU is not in the Lines.  This error is not present in Spreadsheet journal

Warning -- The Header BU 100 does not have any line transactions (5010,257)
The Header BU of the journal you just entered does not have any line transactions. Click OK to continue the Save. Click Cancel to cancel the process. After canceling you may either enter line transactions for the Header BU or or exit the page to discard this journal.

1) Create a spreadsheet journal with anchor BU = A and Line BUs = B
2) import journal
3) Notice no warning is provided.

See replication steps here.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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