360 Degree View - Error Message When Searching For Employee

(Doc ID 2410258.1)

Last updated on JUNE 12, 2018

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE
------------------------
Error message when searching for employee in HRHD 360-Degree View

The environment has Application Security turned on.

Error message
-------------------
A fatal PeopleCode SQL error occurred.

Error in the trace file:

PSAPPSRV.20613 (796) 1-6 12.22.05 7604.992596 SQL error. Function: SQLExec
Error Position: 67
Return: 904 - ORA-00904: "OPRID": invalid identifier
Statement: select count(*) from ps_rc_casen_nonvw where global_flag = 'y' and OPRID = :1 AND BO_ID_CUST = :2 AND DISP_TMPL_FAM_CD = :3 AND CREATION_DATE > :4
Original Statement: select count(*) from %TABLE(:5) WHERE global_flag = 'Y' AND OPRID = :6 AND bo_id_cust = :1 AND DISP_TMPL_FAM_CD = :4 and creation_date > :2

Steps
--------
1. Access 360-Degree View functionality.
2. Search for any employee.
3. Receive the above error.


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