360 Degree View - Error Message When Searching For Employee
(Doc ID 2410258.1)
Last updated on DECEMBER 06, 2019
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |