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 21, 2024

Applies to:

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


On : version, Accounts, Contacts, Households

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

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

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


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

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