Error When Submitting Expense Report: JBO-27122: SQL
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion Expenses Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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
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.
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