After Patch 16108485 not able to access internet Expenses responsibility ORA-00904: "AERH"."APPROVAL_TYPE": invalid identifier (Doc ID 1581896.1)

Last updated on DECEMBER 25, 2015

Applies to:

Oracle Internet Expenses - Version 11.5.10.2 and later
Information in this document applies to any platform.
You have encountered an unexpected error. Please contact the System Administrator for assistance
ORA-00904
"AERH"."APPROVAL_TYPE"
JBO-27122
invalid identifier

Symptoms

On : 11.5.10.2 version, Expense Entry

When attempting to select the Internet expenses responsibility after applying <<Patch 16108485>> ' 1OFF:9848552:APPROVER DISPLAYED INCORRECTLY ON EXPENSE HOME WHEN USING AME',  the following error occurs.

ERROR
-----------------------
"You have encountered an unexpected error. Please contact the System Administrator for assistance."

Exception Details.
 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
AI.DESCRIPTION PURPOSE,
AI.INVOICE_CURRENCY_CODE CURRENCY_CODE,
AI.INVOICE_DATE REPORT_DATE,
AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE,
AI.INVOICE_NUM REPORT_NUMBER,
TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY,0),
  0, decode(AI.CANCELLED_DATE,
  null, APS.GROSS_AMOUNT,


## Detail 0 ##
java.sql.SQLException: ORA-00904: "AERH"."APPROVAL_TYPE": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <<Patch 16108485>> ' 1OFF:9848552:APPROVER DISPLAYED INCORRECTLY ON EXPENSE HOME WHEN USING AME'

   


2. Log into Self Servcie Web Applications
3. Attempt to open any of the responsibilities related to internet expenses
4. The error occurs.



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