My Oracle Support Banner

DATAFIX: GST Receiving Transaction Processor ending in error: ORA-20001: APP--20110: Encountered the error in trigger JAI_RCV_RT_BRI_T1.ORA-06519: active autonomous transaction detected and rolled back (Doc ID 2565807.1)

Last updated on JULY 22, 2019

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Receiving Transaction processor completing in error for Receipt Correction event

ERROR
-----------------------
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP--20110: Encountered the error in trigger JAI_RCV_RT_BRI_T1.ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at ""APPS.JAI_RCV_TAX_DET_PKG"", line 11793
ORA-06512: at ""APPS.JAI_RCV_TAX_DET_PKG"", line 10272
ORA-06510: PL/SQL: unhandled user-defined exception-1 records deleted from jai_det_factors_interface."
fnd.plsql.fnd_file.PUT_LINE "sid:477121095: [31-MAY-19 16:56:51] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.908: Error occured while inserting into rcv_transactions...ORA-20001: APP--20110: Encountered the error in trigger JAI_RCV_RT_BRI_T1.ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at ""APPS.JAI_RCV_TAX_DET_PKG"", line 11793
ORA-06512: at ""APPS.JAI_RCV_TAX_DET_PKG"", line 10272


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform Receipt Correction against Receipt applied on BOE.
2. Notice that RTP is completing in error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot return the goods in inventory.

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


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