My Oracle Support Banner

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 11.12.1.0.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.

Symptoms

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:

ERROR

A system error occurred during processing. Your help desk was notified.
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
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


STEPS
1. Run HCM Extract.
2. Log file shows errors.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.