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 and later
Oracle Fusion Global Human Resources Cloud Service - Version N/A and later
Information in this document applies to any platform.


On : 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.

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

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.

Due to this issue, users cannot run the extracts.


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