Transfer Journal Entries to GL and Journal Import creates records with Negative Ledger_id after Database 19c Upgrade
(Doc ID 2701516.1)
Last updated on AUGUST 17, 2020
Applies to:Oracle Receivables - Version 12 and later
Oracle Payables - Version 12.1.3 and later
Oracle General Ledger - Version 12.1.3 and later
Oracle Subledger Accounting - Version 12.1.3 and later
Information in this document applies to any platform.
GLLEZL: Journal Import
XLAGLTRN: Transfer Journal Entries to GL
Oracle Database - Enterprise Edition - Version 19 and later
Oracle EBS ( Oracle E-Business Suite)
On : 12.2.9 version, Subledger Accounting Uptake for Receivables
To process Final events in Period Close Subledger Exception Report, Customer ran "Transfer Journal Entries to GL"
It spawns "Journal Import"
Unable to query the records in General Ledger.
Find that records have ledger_id is stamped with negative value
For e.g., if the correct ledger_id is 1 , in GL tables (GL_JE_HEADERSand GL_JE_LINES) the value is -1
The issue was seen after Oracle Database Ugprade to 19c
Oracle Database Ugprade to 19
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