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 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!