EEX9.2: Expense Workcenter Filter Causes SQL Error When Applying EMPL_STATUS filter. (Doc ID 2114103.1)

Last updated on MARCH 14, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Pagelets (ESA Portal)

Expense Workcenter Filter causes SQL error when applying EMPL_STATUS

When trying to apply filter to cash advance found through "Open Transactions for Inactive Employees" we receive a SQL error that EMPL_STATUS does not exist in record EX_INACT_EE2_VW.

Steps:
-------

1) Open Expense Workcenter
2) Select Open Transactions for Inactive Employees
3) Click on an open cash advance
4) Click on refine filter criteria and choose a terminated status
5) Apply filter

Statement: SELECT FILL.EMPLID,FILL.ADV_STATUS,FILL.CURRENCY_CD,FILL.TOTAL_AMT,FILL.BALANCE,FILL.ADVANCE_ID,FILL.BUSINESS_PURPOSE,FILL.ADVANCE_NAME,FILL.CREATION_DT,FILL.OPRID_LAST_UPDT,FILL.LASTUPDDTTM FROM PS_EX_INACT_EE2_VW FILL WHERE EMPLID = '035493' AND EMPL_STATUS = 'T'

Original Statement: %SelectAll(:1 FILL) WHERE EMPLID = '035493' and EMPL_STATUS = 'T'
PSAPPSRV.10948 (2981) 1-11458 09.44.44 0.000000 Exception happend in CScrollObjRef::Fill method(), pszWhere=WHERE EMPLID = '035493' and EMPL_STATUS = 'T'


ERROR
-----------------------
SQL0206N



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