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

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

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

Error
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms