My Oracle Support Banner

Oracle Fusion Applications CRM CDM Bulk Import Troubleshooting Guide (Doc ID 1426894.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Fusion Trading Community Hub - Version 11.1.2.0.0 to 11.1.2.0.0 [Release 1.0]
Oracle Fusion Common CRM Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Common CRM - Version 11.1.2.0.0 to 11.1.2.0.0 [Release 1.0]
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Purpose

 

  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.

 

 

Summary:
Technical overview for CDM bulk import (customer)

UI <-> ESS raise Business Event (EDN) SOA mediator & BPEL <-> ESS <-> ODI, PL/SQL package
          <-> ADF Services    



   

Modules / SOA compositeActivityStatus
MKT File Import 




Interface tables populated

Business event raised    
New
|
Scheduled
|
Running
|
Base Table Upload in Progress
|
CDM Import -
Coordinator
CDM batch header tables created |
Pending
CDM Import - Process ODI Matching
|
Processing
|
    1. Complete
2. Completed with Errors
3. Error

 

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
 Problem Catalog:
 Problems & Solutions:
 Problem 1: Status of bulk import job became "Completed with Error"
 Problem 2: Status of bulk import job becomes "Error"
 Solution: (for Problem 3)
 Validation (if applicable):
 Problem 3: Status of File import job stays as "Base table upload in progress"
 3.1. Run the following SQL query on database:
 3.2. Go to CRM EM, find "MktImportAsyncComposite", click on the SOA instance ID to view the flow trace
 3.3. Check if there is any fault threw in flow trace
 Solution: (for Problem 3)
 Problem 4: Status of File import job stays as "Pending"
 Solution: (for Problem 4)
 Validation (if applicable):
 Problem 5: Status of CDM bulk import job stays as "Processing"
 Case 1. The BPEL job pending on waiting for ESS callback
 Solution: (for problem 5)
 Validation (if applicable):
 Problem 6: BPEL flow throw error on invoking ODI
 Solution: (for problem 6)
 Validation (if applicable):
 Problem 7 : Troubleshooting for Employee Resource Import

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