My Oracle Support Banner

Geography Import Error 'REQUEST_GEOGRAPHY_LOAD' Never Established In This Session Or Is Invalid (Doc ID 2699156.1)

Last updated on MARCH 01, 2022

Applies to:

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

Symptoms

On : 11.13.20.04.0 version, Accounts, Contacts, Households

Import Management, Geography import ends with status "Completed with errors".

ERROR
-----------------------
BATCH ID:300000348041915****PLSQL PROCEDURE NAME:HZ_IMP_GEOGRAPHIES_INT.REQUEST_GEOGRAPHY_LOAD***ERROR:ORA-01086: savepoint 'REQUEST_GEOGRAPHY_LOAD' never established in this session or is invalid
Error during Execution of Consumer Data Load Procedure :HZ_IMP_GEOGRAPHIES_INT.REQUEST_GEOGRAPHY_LOAD; For Batch : 300000348041915

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Sign-on to application
2. Navigate to Tools > Import Management
3. Click Create Import Activity
Set Name
Set Object = Geography
File Name: Click on the Choose File button and select the file
4. Click the Next button
5. Click the Next button
6. Click the Submit button

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.