R12: OIE: When User Clicks Return Button on Audit Page Getting Error "You have encountered an unexpected error" (Doc ID 1507638.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When navigating to the iExpenses Audit Page, the following error occurs:

Exception details
Error Details
  Logout
  Error Page
  Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT aerh.REPORT_HEADER_ID,
  aerh.EMPLOYEE_ID,
  aerh.WEEK_END_DATE,
  aerh.CREATION_DATE,
  aerh.CREATED_BY,
  aerh.LAST_UPDATE_DATE,
  aerh.LAST_UPDATED_BY,
  ...
  'N'),
  'N') requires_paperless_audit,
  AP_WEB_AUDIT_UTILS.is_employee_active(aerh.employee_id, aerh.org_id) employee_active,
  AP_WEB_AUDIT_UTILS.get_user_name(aerh.LAST_AUDITED_BY) last_audited_by_name,
  AP_WEB_AUDIT_UTILS.get_user_name(aerh.LAST_UPDATED_BY) last_updated_by_name,
ap_web_audit_utils.get_lookup_description('OIE_AUD_RETURN_REASONS', aerh.return_reason_code) return_reason,
  ep.note_language_code,
  last_auditor.user_name last_auditor_user_name,
  DECODE(usr.employee_id,
  aerh.employee_id, 'Y',
  'N') auditor_own_report,
AP_WEB_POLICY_UTILS.get_lookup_meaning('RECEIPT_STATUS', aerh.RECEIPTS_STATUS) receipt_package_status,
  DECODE(aerh.HOLDING_REPORT_HEADER_ID, null, 'N','Y') hold_status,
  aerh.RECEIPTS_STATUS,
  aerh.attribute_category,
  aerh.attribute1,
  ...
  aerh.attribute15,
  aerh.expense_status_code,
  aerh.expense_last_status_date,
  aerh.holding_report_header_id,
  decode(aerh.source,'Both Pay',pv.vendor_name,
  decode(aerh.source,'CREDIT CARD',pv.vendor_name,null)) CREDIT_CARD_PROVIDER_NAME,
  aerh.prepay_num,
  aerh.advances_justification,
  aerh.MAXIMUM_AMOUNT_TO_APPLY,
  aerh.ADVANCE_INVOICE_TO_APPLY,
  aerh.PREPAY_GL_DATE,
  aerh.PREPAY_DIST_NUM,
  aerh.PAYMENT_CURRENCY_CODE,
  ...
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616)
...
## Detail 0 ##
java.sql.SQLException: Invalid column index

Steps to Reproduce

1. Navigate to Expenses Audit Manager

2. Click Manage Expense Report tab

3. Search for Report Status is Pending Payables Approval 

4. Click on Confirmation Page > Click on View Attachments > Open Attachment

5. Click on  Return to Expense Report

6. Click on  Return button, then below error is displayed

You have encountered an unexpected error. Please contact the system Administrator for assistance.

Cause