Import Nokia Geography Data Process Takes a Long Time to Load US Data (around 8 hours) (Doc ID 2162167.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Tried to load the US Geography data from the Manage Geographies FSM task. The process ran for a very long time and finally completed almost 8 hours later.
Why is this process is taking this long?
 

Example of start and end messages in the process log:
07/15/2016 05:16:24am: Started Geography import for the country US with structures batch id 100000000xxxxxx and hierarchy batch id 100000000xxxxxx
..................
07/15/2016 12:58:55pm: The process completed loading data

Solution

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