My Oracle Support Banner

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)

Symptoms

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

Changes

Oracle Database Ugprade to 19

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


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