My Oracle Support Banner

Fusion HRMS(US): Load Geographies for US Ends in Error, Process Does Not Complete (Doc ID 1626568.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version and later
Oracle Fusion Global Payroll - Version and later
Oracle Fusion Global Human Resources Cloud Service - Version and later
Oracle Fusion HRMS (US) - Version and later
Information in this document applies to any platform.


Load US Geographies ends in error, process does not complete.

Validating input parameters.
Calling Sql*Loader to load data.
Submitted child request with id ::4419
Checking status of child request::4419
Data uploaded into interface table. No. of records: 133041
Error in API ::: hrx_us_load_file
Trying to upload an older version of geography data file

The issue can be reproduced at will with the following steps:
1) Navigator/Setup and Maintenance/Load Geographies and US/Click on Go to Task
2) On the Processes tab, click the “Validate Input Parameters and Load Geography” record
3) Enter the following:
Data Source = Vertex
File Location=/u01/APPLTOP/fusionapps/applications/thirdparty/hcm/vertex/stub/
File Name = oramast.txt
4) Do the same for Run Post Processing
5) Submit
6) Navigator/Scheduled Processes
7) Process ends 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.