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