Manage US Geography Interface Table Data process failed with Error

Summary:

Manage US Geography Interface Table Data process failed with Error

Content (required):

We ran the Load US Geography Data process. The sub process/child process "Manage US Geography Interface Table Data" failed with below error.

ORA-01427: single-row subquery returns more than one row at ORA-06512: at "FUSION.HRX_US_GEOGRAPHY_LOAD", line 1312

Error in hrx_us_generate_geography_id: ORA-01403: no data found at ORA-06512: at "FUSION.HRX_US_GEOGRAPHY_LOAD", line 1353

Attached the log file for your reference.

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):