HCM Extract Based On PER_EXT_SEC_ASSIGNMENT_UE Returns ORA-01427 Error (Doc ID 1502248.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.4.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : 11.1.4.0.0 version, Set Up Workforce Deployment-Define Extracts

A simple extract based on PER_EXT_SEC_ASSIGNMENT_UE and using element person first name has an error while running it.


ERROR
-----------------------
oracle.xdo.XDOException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row


STEPS
-----------------------
1. Navigate to Data Exchange and define a new extract under an LDG and extract block using PER_EXT_SEC_ASSIGNMENT_UE with one element first name
2. Navigate to Payroll >Checklist>Submit a Process or Report and enter LDG and select o your extract name
3. Submit the extract you created.


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot run the extracts.

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