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.

Symptoms

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.

 

Issue:2:

-----------

1. Try uploading a budget journal.

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


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

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
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.