How To Manage Performance Of Import Of Parties To TCA

(Doc ID 1505129.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Common CRM - Version 11.1.5.0.0 and later
Oracle Fusion Common CRM Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Trading Community Model - Version 11.1.5.0.0 and later
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Goal

How to optimise TCA import process?


Total time 07:06, of which 06:35 was the TCA import process. In particular, the FoundationBulkImportProcess_HZ_IMPORT_MATCH, _VALIDATE 
and _LOAD processes took a surprising amount of time for one record, over half the total. Can we get these to operate more efficiently? 
Also, is there a way to cut out steps we don't need? For instance, we're not using geographies at all; can we remove the geography validation steps?

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms