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