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 DECEMBER 19, 2016

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

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:
12/3/12 9:37 PM 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: Query: INSERT INTO GL_INTERFACE(GROUP_ID,SEGMENT1,CREATED_BY,CURRENCY_CODE,PERIOD_NAME,ACTUAL_FLAG,DATE_CREATED,STATUS,JE_BATCH_ID,ACCOUNTING_DATE,ENTERED_CR,LEDGER_ID,USER_JE_SOURCE_NAME,ENTERED_DR,BUDGET_VERSION_ID,SEGMENT8,USER_JE_CATEGORY_NAME,SEGMENT7,SEGMENT6,SEGMENT5,SEGMENT4,SEGMENT3,SEGMENT2) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23)
12/3/12 9:37 PM Web ADI Upload Job 94460 ERROR          BneBaseSQL.forceBatchExecute: Args : null, 01, 6383, MXP, APR-12, B, 2012-12-03 00:00:00.0, NEW, 1017, 2012-04-01 00:00:00.0, null, 82, Budget - Upload, 30000, 1200, 44, Budget - Upload, 440, 00, 22, 00, 0000, 51400101
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="http://www.oracle.com/bne"><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." ><bne:context  bne:collection="collection_1" bne:idx="4" /></bne:message><bne:message bne:type="DATA" bne:text="BNE_VALID_ROW_COUNT" bne:value="3" /><bne:message bne:type="DATA" bne:text="BNE_INVALID_ROW_COUNT" bne:value="1" /><bne:message bne:type="STATUS" bne:text="No rows uploaded" bne:value="" ><bne:context  bne:collection="collection_1" /></bne:message><bne:message bne:type="STATUS" bne:text="1 rows were invalid" bne:value="" ><bne:context  bne:collection="collection_1" /></bne:message></bne:document>



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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms