When Creating iExpense Report, You have encountered an unexpected error JBO-27122 Being Thrown (Doc ID 360253.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
When attempting to create an iExpense report, the following error occurs.


Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.

detail error
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: SELECT * FROM (SELECT ExpenseReportLineEO.REPORT_HEADER_ID,
ExpenseReportLineEO.LAST_UPDATE_DATE,
ExpenseReportLineEO.LAST_UPDATED_BY,
ExpenseReportLineEO.CODE_COMBINATION_ID,
ExpenseReportLineEO.ITEM_DESCRIPTION,
ExpenseReportLineEO.SET_OF_BOOKS_ID,
ExpenseReportLineEO.AMOUNT,
ExpenseReportLineEO.ATTRIBUTE_CATEGORY,
ExpenseReportLineEO.ATTRIBUTE1,
ExpenseReportLineEO.ATTRIBUTE2,
ExpenseReportLineEO.ATTRIBUTE3,
ExpenseReportLineEO.ATTRIBUTE4,
ExpenseReportLineEO.ATTRIBUTE5,
ExpenseReportLineEO.ATTRIBUTE6,
ExpenseReportLineEO.ATTRIBUTE7,
ExpenseReportLineEO.ATTRIBUTE8,
ExpenseReportLineEO.ATTRIBUTE9,
ExpenseReportLineEO.ATTRIBUTE10,
ExpenseReportLineEO.ATTRIBUTE11,
ExpenseReportLineEO.ATTRIBUTE12,
ExpenseReportLineEO.ATTRIBUTE13,
ExpenseReportLineEO.ATTRIBUTE14,
ExpenseReportLineEO.ATTRIBUTE15,
ExpenseReportLineEO.CURRENCY_CODE,
ExpenseReportLineEO.EXCHANGE_RATE,
ExpenseReportLineEO.VAT_CODE,
ExpenseReportLineEO.LINE_TYPE_LOOKUP_CODE,
ExpenseReportLineEO.LAST_UPDATE_LOGIN,
ExpenseReportLineEO.CREATION_DATE,
ExpenseReportLineEO.CREATED_BY,
ExpenseReportLineEO.PROJECT_ACCOUNTING_CONTEXT,
ExpenseReportLineEO.PROJECT_ID,
ExpenseReportLineEO.TASK_ID,
ExpenseReportLineEO.EXPENDITURE_ORGANIZATION_ID,
ExpenseReportLineEO.EXPENDITURE_TYPE,
ExpenseReportLineEO.EXPENDITURE_ITEM_DATE,
ExpenseReportLineEO.DISTRIBUTION_LINE_NUMBER,
ExpenseReportLineEO.ORG_ID,
ExpenseReportLineEO.RECEIPT_VERIFIED_FLAG,
ExpenseReportLineEO.JUSTIFICATION_REQUIRED_FLAG,
ExpenseReportLineEO.RECEIPT_REQUIRED_FLAG,
ExpenseReportLineEO.RECEIPT_MISSING_FLAG,
ExpenseReportLineEO.JUSTIFICATION,
ExpenseReportLineEO.EXPENSE_GROUP,
ExpenseReportLineEO.START_EXPENSE_DATE,
ExpenseReportLineEO.END_EXPENSE_DATE,
ExpenseReportLineEO.RECEIPT_CURRENCY_CODE,
ExpenseReportLineEO.RECEIPT_CONVERSION_RATE,
ExpenseReportLineEO.DAILY_AMOUNT,
ExpenseReportLineEO.RECEIPT_CURRENCY_AMOUNT,
ExpenseReportLineEO.WEB_PARAMETER_ID,
ExpenseReportLineEO.AMOUNT_INCLUDES_TAX_FLAG,
ExpenseReportLineEO.ADJUSTMENT_REASON,
ExpenseReportLineEO.AWARD_ID,
ExpenseReportLineEO.TAX_CODE_ID,
ExpenseReportLineEO.MERCHANT_DOCUMENT_NUMBER,
ExpenseReportLineEO.MERCHANT_NAME,
ExpenseReportLineEO.MERCHANT_REFERENCE,
ExpenseReportLineEO.MERCHANT_TAX_REG_NUMBER,
ExpenseReportLineEO.MERCHANT_TAXPAYER_ID,
ExpenseReportLineEO.TAX_CODE_OVERRIDE_FLAG,
ExpenseReportLineEO.CREDIT_CARD_TRX_ID,
ExpenseReportLineEO.ITEMIZE_ID,
ExpenseReportLineEO.COMPANY_PREPAID_INVOICE_ID,
ExpenseReportLineEO.PROJECT_NUMBER,
ExpenseReportLineEO.TASK_NUMBER,
ExpenseReportLineEO.AWARD_NUMBER,
ExpenseReportLineEO.PROJECT_NAME,
ExpenseReportLineEO.TASK_NAME,
ExpenseReportLineEO.VEHICLE_CATEGORY_CODE,
ExpenseReportLineEO.VEHICLE_TYPE,
ExpenseReportLineEO.FUEL_TYPE,
ExpenseReportLineEO.NUMBER_PEOPLE,
ExpenseReportLineEO.DAILY_DISTANCE,
ExpenseReportLineEO.AVG_MILEAGE_RATE,
ExpenseReportLineEO.DESTINATION_FROM,
ExpenseReportLineEO.DESTINATION_TO,
ExpenseReportLineEO.TRIP_DISTANCE,
ExpenseReportLineEO.LOCATION_ID,
ExpenseReportLineEO.ATTENDEES,
ExpenseReportLineEO.TICKET_CLASS_CODE,
ExpenseReportLineEO.TICKET_NUMBER,
ExpenseReportLineEO.FLIGHT_NUMBER,
ExpenseReportLineEO.LICENSE_PLATE_NUMBER,
ExpenseReportLineEO.DISTANCE_UNIT_CODE,
ExpenseReportLineEO.NUMBER_ATTENDEES,
ExpenseReportLineEO.NUM_PDM_DAYS1,
ExpenseReportLineEO.NUM_PDM_DAYS2,
ExpenseReportLineEO.NUM_PDM_DAYS3,
ExpenseReportLineEO.PER_DIEM_RATE1,
ExpenseReportLineEO.PER_DIEM_RATE2,
ExpenseReportLineEO.PER_DIEM_RATE3,
ExpenseReportLineEO.DEDUCTION_ADDITION_AMT1,
ExpenseReportLineEO.DEDUCTION_ADDITION_AMT2,
ExpenseReportLineEO.DEDUCTION_ADDITION_AMT3,
ExpenseReportLineEO.NUM_FREE_BREAKFASTS1,
ExpenseReportLineEO.NUM_FREE_LUNCHES1,
ExpenseReportLineEO.NUM_FREE_DINNERS1,
ExpenseReportLineEO.NUM_FREE_ACCOMMODATIONS1,
ExpenseReportLineEO.NUM_FREE_BREAKFASTS2,
ExpenseReportLineEO.NUM_FREE_LUNCHES2,
ExpenseReportLineEO.NUM_FREE_DINNERS2,
ExpenseReportLineEO.NUM_FREE_ACCOMMODATIONS2,
ExpenseReportLineEO.NUM_FREE_BREAKFASTS3,
ExpenseReportLineEO.NUM_FREE_LUNCHES3,
ExpenseReportLineEO.NUM_FREE_DINNERS3,
ExpenseReportLineEO.NUM_FREE_ACCOMMODATIONS3,
ExpenseReportLineEO.ITEMIZATION_PARENT_ID,
ExpenseReportLineEO.TRAVEL_TYPE,
ExpenseReportLineEO.FLEX_CONCATENATED,
ExpenseReportLineEO.LOCATION,
ExpenseReportLineEO.CATEGORY_CODE,
decode(RECEIPT_VERIFIED_FLAG, 'Y', 'ReceiptVerifiedCheck', 'ReceiptVerifiedBlank') AS
RECEIPT_VERIFIED_SWITCHER,
decode(RECEIPT_MISSING_FLAG, 'Y', 'ReceiptMissingCheck', 'ReceiptMissingBlank') AS
RECEIPT_MISSING_SWITCHER,
ExpenseReportLineEO.SUBMITTED_AMOUNT,
ExpenseReportLineEO.REPORT_LINE_ID
FROM AP_EXPENSE_REPORT_LINES_ALL ExpenseReportLineEO
WHERE ExpenseReportLineEO.REPORT_HEADER_ID = :1
AND nvl(category_code, 'NULL') <> 'MILEAGE' AND nvl(category_code, 'NULL') <> 'PER_DIEM')
QRSLT ORDER BY DISTRIBUTION_LINE_NUMBER
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:132)
at
oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:756)
at oracle.apps.ap.oie.webui.HeaderCO.processRequest(HeaderCO.java:350)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:581)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at
oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
.....

at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)


STEPS
The issue can be reproduced at will with the following steps:
1. Choose responsibility
2. Expenses Home
3. Create Expense Report

Changes

 

Cause

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