The Process HGA_EMP_REF Goes To No Success (Doc ID 2133176.1)

Last updated on MAY 06, 2016

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Delivered Process HGA_EMP_REF,
the following error occurs.

ERROR
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 51 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: UPDATE PS_HGA_PG_EMP_LNG SET CONTRACT_TYPE_DESC = (( SELECT B.DESCR FROM PS_HGA_PG_EMP_DET A , PS_PERS_CNTTYP_LNG B , PS_REG_REGION_TBL REG , PS_CONTRACT_DATA CDAT WHERE CDAT.EMPLID = A.EMPLID AND CDAT.CONTRACT_NUM = A.CONTRACT_NUM AND REG.REG_REGION = CDAT.REG_REGION AND REG.DEFAULT_SETID = B.SETID AND A.EMPLID = PS_HGA_PG_EMP_LNG.EMPLID AND A.EMPL_RCD = PS_HGA_PG_EMP_LNG.EMPL_RCD AND B.CONTRACT_TYPE = A.CONTRACT_TYPE AND B.LANGUAGE_CD = PS_HGA_PG_EMP_LNG.LANGUAGE_CD )) WHERE EXISTS ( SELECT 'X' FROM PS_HGA_PG_EMP_DET C , PS_PERS_CNTTYP_LNG D , PS_REG_REGION_TBL REG , PS_CONTRACT_DATA CDAT WHERE CDAT.EMPLID = C.EMPLID AND CDAT.CONTRACT_NUM = C.CONTRACT_NUM AND REG.REG_REGION = CDAT.REG_REGION AND REG.DEFAULT_SETID = D.SETID AND C.EMPLID = PS_HGA_PG_EMP_LNG.EMPLID AND C.EMPL_RCD = PS_HGA_PG_EMP_LNG.EMPL_RCD AND D.CONTRACT_TYPE = C.CONTRACT_TYPE AND D.LANGUAGE_CD = PS_HGA_PG_EMP_LNG.LANGUAGE_CD AND D.EFFDT <= TO_DATE('2016-02-01','YYYY-MM-DD'))

Process 12575 ABENDED at Step HGA_EMP_REF.CONTR_LN.Step01 (SQL) -- RC = 1427 (108,524)

STEPS
The issue can be reproduced at will with the following steps:
1. Perform the required Absence Setup for Standard Absence
2. Navigate to Main Menu > Setup HCM > Global Payroll & Absence Management > Absence and Payroll Processing, then select Refresh Employee Information
3. Click Run on this page to initiate the Refresh Employee Info (HGA_EMP_REF) Application Engine process, which updates employee data with the most current data.
4. The Process goes to No Success

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