My Oracle Support Banner

File Import Troubleshooting Guide (Doc ID 1394406.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

Oracle Fusion Marketing - Version 1.0-Beta to 11.1.3.0.0 [Release 1.0]
Oracle Fusion Marketing Cloud Service - Version 11.1.10.0.0 to 11.13.17.05.0 [Release 1.0]
Information in this document applies to any platform.

Purpose

File Import Wizard provides a generic import framework to support data import from text and xml files into transactional tables.
On a high level the import process is a 3 step process, which includes file processing, validation and creation of data in the destination.
Data can exist from various sources and in various formats. File processing component consists of reading the source data, parsing the data and inserting into the appropriate staging tables. During the process, user defined mapping is read and the data is inserted as per the mapping.

If you are a Software-as-a-Service (SaaS) customer, there are multiple sections in this document that need not be performed by you. Please log a Service Request in My Oracle Support for Oracle to do this for you.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Dependent Technologies
 Standard Logging Practices
 Problem 1 - Cannot see the object in the create import activity page
 Problem 2 - Error on uploading file in create file import activity
 Problem 3 - Error on Activating the import activity
 Problem 4 - Import Activity stays in scheduled status
 Problem 5 - Import Activity status in Interface Upload in Progress status 
 Problem 6 - Import Activity status in Base Table Upload in Progress status
 Problem 7 - Import Activity status in Completed Status but no records imported
 Problem 8 - Import Activity status in Completed With Error status

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