US Payroll Legislation: Load Geographies for US ends in error : ERROR: ORA-00001: unique constraint (FUSION.HZ_GEOGRAPHY_IDENTIFIERS_U1) violated while executing BEGIN HRX_US_GEOGRAPHY_CUSTOM_LOAD.HRX_US_CUSTOM_GEO_CREATE
(Doc ID 2745051.1)
Last updated on JANUARY 19, 2021
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.0 version, Country/Region Legislations
When attempting to run Load US Geography Data process showed warning but in the Manage US Geography Post Processing logs the following error occurs.
Warning in hrx_us_post_process_data: Sub request 2180797 failed with error/warning message ::::ERROR:ESS-01708 Database job for request 2180797 ended with error: SQL execution error. JobName: "FUSION_RUNTIME"."ESS1$JB_2180797"
--- SQL Execution Error ---
ErrorMsg: [ORA-20979: Request 2180797 encountered ERROR: ORA-00001: unique constraint (FUSION.HZ_GEOGRAPHY_IDENTIFIERS_U1) violated while executing BEGIN HRX_US_GEOGRAPHY_CUSTOM_LOAD.HRX_US_CUSTOM_GEO_CREATE(:errbuf, :retcode ); END; at ORA-06512: at "FUSION.HRX_US_GEOGRAPHY_CUSTOM_LOAD", line 1404
ORA-06512: at "FUSION.H
The issue can be reproduced at will with the following steps:
1. for monthly Vertex update of December, Load US Geography Data process;
2. sub-process Load additional US Geography Data, seen in Error
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