My Oracle Support Banner

E-GL 9.2 (JRNL1_WS) Journal Upload Spreadsheet Is Not Validating LEDGER/LEDGER_GROUP Value For Intra/Inter Business Unit Transactions (Doc ID 2526381.1)

Last updated on MAY 12, 2021

Applies to:

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


Journal Upload Spreadsheet is not validating LEDGER/LEDGER_GROUP value for Business unit

When Using Journal Upload spreadsheet (JRNL1_WS) if a LEDGER/LEDGER_GROUP value is entered which is not a valid for the header business unit, but is valid for the Line BU the template throws a bad error message that lacks detail.

"Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:"

The issue can be reproduced at will with the following steps:
1. Setup/Fin Supply Chain > By related > GL > Ledgers For a Unit > US001
2. Remove Projects ledger Group
3. Open JRNL1_WS
4. Setup & Defaults:
  -Check "Edit Journals"
  -Ledger Group Projects
5. Add new Sheet
6. Add Header with US001
7. Add Lines With US005
6. Click Import Now




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.