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.
Symptoms
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.
ERROR
-----------------------
"Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:"
STEPS
-----------------------
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
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |