My Oracle Support Banner

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 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

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

ERROR
-----------------------
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 ---
ErrorCode: 20979
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


STEPS
-----------------------
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


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