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.
On : 11.13.20.04.0 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 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