Fusion Global HR: ORA-00054 Error In The Pre Processing Step Of Load Us Geographies (Doc ID 1414051.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.2.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


Error received from running the load US Geographies

In API :: hrx_us_generate_geography_id
After State Update, rows processed:59, in time (ms):50
After State Name Change Update, rows processed:59, in time (ms):320
After County Update, rows processed:3240, in time (ms):17250
After County Name Change Update, rows processed:3239, in time (ms):16690
After City Update, rows processed:0, in time (ms):270
After Township Update, rows processed:8654, in time (ms):150
After City and Township Name Change Update, rows processed:8647, in time (ms):63370
After School District Update, rows processed:4235, in time (ms):70
After School District Name Change Update, rows processed:4235, in time (ms):23350
After new State,County,Township and School District Update, rows processed:16180, in time (ms):920
After new City Update, rows processed:45682, in time (ms):2600
After new City 2nd Update, rows processed:66, in time (ms):380
After GeoCode Identifier Update, rows processed:48980, in time (ms):2790
After GeoCode Identifier Update, rows processed:59, in time (ms):40
After Primary City Identifier Update, rows processed:41669, in time (ms):1310
After Zip and Alternate City Update, rows processed:63075, in time (ms):387250
Generated and updated interface table with geography ids and status
Calling API to create master reference geographies. Process ID:: 809
Error in API hrx_us_process_data : Sub request 809 failed with error/warning message ::::ERROR:ESS-01708 Database job for request 809 ended with error: JobName: FUSION_RUNTIME.ESS1$JB_809; ErrorCode: 20969; ORA-20969: Request 809 exited with ERROR: :
ORA-06512: at "FUSION.FND_EXECUTE", line 305
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
ORA-06512: at "FUSION.FND_EXECUTE", line 358
ORA-06512: at "FUSION.FND_EXECUTE", line 343
ORA-06512: at line 1
ORA-06512: at "FUSION_ORA_ESS.ESS_SCHJOB_PROC", line 11
.
Viewed the error log of sub process 809 and I got the following:
In API : hrx_us_create_geography
Unexpected Error in hrx_us_create_geography: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

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