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:

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

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