My Oracle Support Banner

R12: Web ADI: Upload Error ORA-20001 Occurs For Few Lines But The Data Is Inserted Into GL_INTERFACE (Doc ID 1574945.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.


On : 12.0.6 version, Journal Entry

When attempting to upload journals via excel spreadsheet web adi,
the following error occurs, user faces 2 issues:

Issue :1

The issue can be reproduced at will with the following steps:
1.Web ADI spreadsheet --> Enter journals --> Oracle--> Upload
2. error occurs: "Invalid Rows"

3. But, observed that data gets inserted to GL_INTERFACE inspite of the error.




1. Try uploading a budget journal.

2. For some rows it shows ORA-20001 error upon uploading

The issue has the following business impact:
Due to this issue, users cannot upload journals via web ADI


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.