My Oracle Support Banner

R12 When Uploading Budget Journal Using WEBADI Launch Journal Wizard get "Cannot execute SQL statement" and BNE Log shows ORA-04098: Trigger 'APPS.BS_AC_TRG_TXF_TO_LE_SOB' is Invalid and Failed Re-Validation (Doc ID 1512288.1)

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.0.6 to 12.2.1 [Release 12 to 12.2]
Oracle General Ledger - Version 12.0.6 to 12.2.1 [Release 12.0 to 12.2]
Information in this document applies to any platform.
Reviewed 19-Dec-2016

Symptoms

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

On : 12.1.3 version, Web ADI Budget Upload

When attempting to upload Budget Journals from WEBADI the Launch Journal Wizard menu function, for either a previously saved spreadsheet or a newly created spreadsheet, the following error occurs:-
When create a new Budget Journal spreadsheet using the Launch Journal Wizard in GL, then the same issue occurs.

ERROR
-----------------------
Cannot execute SQL statement

 

The FND Log shows the following error:
Web ADI Upload Job 94460 ERROR          BneBaseSQL.forceBatchExecute: Exception while running executeBatch.  Error Code: 4098, Message: ORA-04098: trigger 'APPS.BS_AC_TRG_TXF_TO_LE_SOB' is invalid and failed re-validation
...
12/3/12 9:37 PM Web ADI Upload Job 94460 ERROR          BneBaseSQL.forceBatchExecute: Stack trace: java.sql.BatchUpdateException: ORA-04098: trigger 'APPS.BS_AC_TRG_TXF_TO_LE_SOB' is invalid and failed re-validation

12/3/12 9:37 PM AJPRequestHandler-HTTPThreadGroup-16 TRACE          SettingValue: <bne:document xmlns:bne="URL"><bne:message bne:type="ERROR" bne:text="Cannot execute SQL Statement." bne:cause="A low level API call failed." bne:action="Please note this error to your support representative." >



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Custom GL Super User Responsibility
2. Select the Launch Journal Wizard menu function.
3. Select The Budget Single Integrator
4. Enter the data in the template and upload the template

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


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