My Oracle Support Banner

Fusion : Error Situations And Debug Examples Of TCA Import Program : Partners - Customers - Consumers - Organization Contacts - Geography (Doc ID 1337507.1)

Last updated on OCTOBER 29, 2023

Applies to:

Oracle Fusion Partner Management - Version 1.0-Beta to [Release 1.0]
Oracle Fusion Common CRM - Version 1.0-Beta to [Release 1.0]
Oracle Fusion Common CRM Cloud Service - Version and later
Oracle Fusion Partner Relationship Management for Partners Cloud Service - Version and later
Oracle Fusion Trading Community Hub - Version 1.0-Beta and later
Information in this document applies to any platform.


Purpose of this document is to expose in scope of Fusion Applications :
Some Error Situations And Debug Examples Of Partner Import Program

  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.



Audience is any user consultant or support engineer who needs to debug Partner Imports  


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
 1. Scripts To Debug Mapping
 2. Scripts To Debug Import
 3. Examples Of Errors Messages And Data Feeding Issues
 A)  Orig system not coherent between Partner and Partner Contact
 B) Mapping mismatch
 C)  Datamodel change : e.g. new NOT NULL field
 D)  Even if at Top of Tree Hierarchy populate the parent  tree code
 E)  About Partner Status field
 F) Global Rules To Manage relationships between Party, Party_site, Locations , Contacts Points
 G) Method To Uptake SQL Import by filling Import tables : ZPM_IMP%  after using Import Partner from a file (text of xml)
 H) Organization Contacts Error When Importing Only Contacts   JBO-25058
 I) Full example of SQL based Import (in HZ_IMP% tables)

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