R12: OIE: Error JBO-26041 Failed To Post Data To Database During "Insert" Error When Creating A New Expense Report On The Cash And Other Expenses Multi-line Page
(Doc ID 1598875.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Oracle Internet Expenses - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Error JBO-26041 Failed To Post Data To Database During "Insert"
Cash and Other Expenses Multi-line Page
Symptoms
When attempting to create a new expense report the Receipt Based Expenses : Cash and Other Expenses multi-line page receives the following error when selecting the NEXT button:
Error
oracle.jbo.DMLException: JBO-26041 Failed to post data to database during "Insert": SQL Statement" INSERT INTO AP_EXPENSE_REPORT_LINES_ALL
(REPORT_HEADER_ID, LAST_UPDATE_DATE,LAST_UPDATED_BY,ITEM_DESCRIPTION,SET_OF_BOOKS_ID,AMOUNT,CURRENCY_CODE,LINE_TYPE_LOOKUP_CODE,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DISTRIBUTION_LINE_NUMBER,ORG_ID,RECEIPT_REQUIRED,FLAG ( Cut off in screeshot at this point)
...
VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25)".
oracle.jbo.DMLException: JBO-26041 Failed to post data to database during "Insert": SQL Statement" INSERT INTO AP_EXPENSE_REPORT_LINES_ALL
(REPORT_HEADER_ID, LAST_UPDATE_DATE,LAST_UPDATED_BY,ITEM_DESCRIPTION,SET_OF_BOOKS_ID,AMOUNT,CURRENCY_CODE,LINE_TYPE_LOOKUP_CODE,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DISTRIBUTION_LINE_NUMBER,ORG_ID,RECEIPT_REQUIRED,FLAG ( Cut off in screeshot at this point)
...
VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25)".
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! |