Fusion Global HR: HCM Extract Receives Name HR_6881_HRPROC_ORA_ERR when Nationality Database Item (DBI) Is Added to PER_EXT_PAY_EMPLOYEES_UE User Entity
(Doc ID 2426050.1)
Last updated on SEPTEMBER 03, 2020
Applies to:Oracle Fusion Global Human Resources - Version 126.96.36.199.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.
This note was created for Release 11.13.18.02.0. The note has been reviewed and is current for release 11.13.20.04.0.
When the Nationality Database Item (DBI) is added to the PER_EXT_PAY_EMPLOYEES_UE user entity(UE) of the extract, it fails with the following error:
Token2 ORA-20001: Formula EXT_PERSON_DATA3000000111111_3000000111111, line 137, no data returned. Details: Item HWP_PER_NATIONALITY returned no data. This error most commonly occurs when a database item query returns no data, but the database item is configured not to allow no return data. It can also occur within a formula function call.
ORA-06512: at "FUSION.FF_EXEC", line 3769
ORA-06512: at "FUSION.FF_EXEC", line 3779
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2080
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1962
1. Run HCM Extract.
2. Log file shows errors.
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