ETL 9.1 TL_MSS_SRCH_SBP Page - Field Group_id Is Active Since Upgrade And Causing Search Issues. (Doc ID 1533986.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Aug-2014***

Symptoms

While trying to search employees by entering group id, the page throws following error message.

ERROR
-----------------------

  Error Position: 1445
  Return: 904 - ORA-00904: "J"."GROUP_ID": invalid identifier
  Original Statement: SELECT /*+ RULE */ DISTINCT J.EMPLID ,J.EMPL_RCD ,A.NAME ,J.BUSINESS_UNIT ,J.JOBCODE ,JC.DESCR ,J.DEPTID ,D.DESCR ,J.SUPERVISOR_ID ,J.REPORTS_TO ,J.LOCATION ,J.COMPANY ,J.PAYGROUP ,J.GP_PAYGROUP ,ED.WORKGROUP ,ED.TASKGROUP ,J.POSITION_NBR FROM PS_JOBCODE_TBL JC , PS_JOB J , PS_TL_EMPL_DATA ED, PS_TL_GROUP_DTL F ,PS_TL_GRP_SECURITY S ,PS_PERSON_NAME A , PS_DEPT_TBL D WHERE S.TL_GROUP_ID = F.TL_GROUP_ID AND F.EMPLID = J.EMPLID AND F.EMPL_RCD = J.EMPL_RCD AND F.EMPLID = A.EMPLID AND F.EMPLID = ED.EMPLID AND F.EMPL_RCD = ED.EMPL_RCD AND S.ROWSECCLASS = :1 AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT '910221007' AND EXISTS (SELECT 'X' FROM PS_TL_PAYABLE_TIME AP WHERE J.EMPLID=AP.EMPLID AND J.EMPL_RCD=AP.EMPL_RCD AND AP.DUR BETWEEN %datein('2013-01-27') AND %datein('2013-02-09') AND AP.PAYABLE_STATUS='NA' AND AP.SEQ_NBR IN (SELECT SEQ_NBR FROM PS_TL_APP_PAY_VW WHERE OPRID=%OperatorID))
PSAPPSRV.2473 (1974) 1-884578 07.53.06 0.028788 ErrorReturn-> 280 - SQL error in Exec. (2,280) TL_COMMON.EmployeeList.GetEmployees.OnExecute Name:EmployeeList PCPC:1943 Statement:54
Called from:FUNCLIB_TL_CP.MGR_SS_FUNC.FieldFormula Name:PrepToLoadEmployees Statement:369
Called from:FUNCLIB_TL_TR.EMPL_FUNC.FieldFormula Name:Get_Employees_Aprvl Statement:18
Called from:TL_MSS_SRCH_WRK.GET_EMPLOYEES.FieldChange Statement:12

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. login into PIA,
2. Navigate to manager self service > Time management > Approve Time and Exceptions > Payable time
3.enter group id in the blank field value and also on the Time Reporter group id
4. click on get employees
5 The system throws the following error message.

The issue has the following business impact:
Due to this issue, users cannot search employees for approvals.

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