HCM Extract Goes Into Error When Nationality DBI Of PER_EXT_PAY_EMPLOYEES_UE UE Is Added
(Doc ID 2426050.1)
Last updated on JULY 23, 2018
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.
When Nationality DBI is added to the Extract, it fails with following error
A system error occurred during processing. Your help desk was notified.
Token2 ORA-20001: Formula EXT_PERSON_DATA300000015683489_300000015683489, 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!