My Oracle Support Banner

When Trying To Create a Receipt having BOE applicability, Encountering Error Message: JAI_RCV_RT_BRI_T1.ORA-06519: active autonomous transaction detected and rolled back (Doc ID 2537640.1)

Last updated on MAY 02, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, GST Payables

When attempting to create a receipt after matching to BOE,
the following error occurs.

ERROR
-----------------------
RVTTH-192: rvtthins: Subroutine 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_T"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N)->India Local Payables
2. Create BOE invoice
3. Create receipt after matching the BOE.
Observe the issue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
1. UAT is stuck as the users cannot demo the Imports Flow

Changes

FND Debug log shows the following error message:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
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 11904
ORA-06512: at ""APPS.JAI_RCV_TAX_DET_PKG"", line 10400

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


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