My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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
 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.


To view full details, 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 a vibrant support community of peers and Oracle experts.