Error When Submitting Expense Report: JBO-27122: SQL (Doc ID 2132948.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Expenses Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.11.1.0 version, Other Issues


When submitting an expense report, getting the following error:

An application error occurred. See the incident log for more information.
Incident log shows following error:

Caused by: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
 preparation. Statement: select r.expense_report_id, expense_report_num from
 exm_expense_reports r
 where r.person_id = :personId AND r.assignment_id = :assignmentId AND
 (expense_status_code=:savedStatus OR expense_status_code=:rejectedStatus OR
 expense_status_code=:withdrawnStatus)
 AND exists (select 'Y' from exm_expenses x, exm_credit_card_trxns cc
 where x.expense_report_id=r.expense_report_id and
 x.credit_card_trxn_id=cc.credit_card_trxn_id and trunc(cc.posted_date) <
 trunc(sysdate- :ageLimit) and rownum=1)

Then try to submit the expense report again, and it allows  to process the expense report through. This is happening for all users.
 

Solution

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