EAR9.2:AR WorkCenter - SQL Error Received When Using "IN" Operator For SetId In Filter (Doc ID 2093772.1)

Last updated on JANUARY 04, 2016

Applies to:

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

Symptoms

On : 9.2 version, Pending Item Entry

When attempting to Select ‘IN’ as the Operator for the SetId field and click on the magnifying glass at Main Menu > Accounts Receivable > AR WorkCenter,
the following error occurs.

ERROR
-----------------------
SQL error. Function: Rowset.Fill
Error Position: 104
Return: 904 - ORA-00904: "OPRCLASS": invalid identifier
Statement: select fill.setid,fill.descr,fill.descrshort,fill.descrlong from ps_sp_setid_nonvw fill where 1 = 1 and OPRCLASS = 'H5_CBA'
Original Statement: %SelectAll(:1 FILL) WHERE 1 = 1 AND OPRCLASS = 'H5_CBA'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Navigate to :- Main Menu > Accounts Receivable > Receivables WorkCenter.
  2. Click on the ‘Edit Filters’ link.
  3. Click on ‘Edit Filter’ against ‘Open Items’.
  4. Select ‘in’ as the Operator for the SetId field and click on the magnifying glass. Following error message appears.




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