My Oracle Support Banner

The Manage Geographies, Import Geography Data Process Ends In Error (Doc ID 2865541.1)

Last updated on APRIL 27, 2022

Applies to:

Oracle Fusion CX Sales Cloud Service - Version 11.13.22.01.0 and later
Information in this document applies to any platform.

Symptoms

The Manage Geographies, Import Geography Data process ends in error.

ERROR
-----------------------
Parent Process:
Subrequest to populate geography data submitted with job ID: 999999
Error in populating geography data to staging tables. Please check the Subrequest for the details.

Sub Process:
SQL*Loader-951: Error calling once/load initialization
ORA-26028: index FUSION.FOD_STAGE_GEO_STRUCTURES_U1 initially in unusable state

Error occurred in loading data to staging tables.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Sign-on to application as administrator
2. Navigate to Setup and Maintenance > Manage Geographies
3. Search for the Country Code
4. Click on Actions > Import Geography Data
5. Monitor the process which ends in error

Cause

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
Symptoms
Cause
Solution
References


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