In file Import No Data Populated To Custom Fields (Doc ID 2016375.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Customer Center - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
 No data is imported to custom organization fields

When importing text values to a custom text field that is part of the organizationprofile.

The import seems to be correct and status shows successful. Data is loaded successfully in interface tables but not in actual tables.
In this case, a custom field for Organization Profile objects is imported/
Following mapping were attempted:

OrganizationProfile_ObjectKey >>PartyId
OrganizationProfileExtn_PartyId
OrganizationProfileExtn_Eloqua_SalesOwner_c

This custom field is mapped to EXTN_ATTRIBUTE_CHAR006 .

Table HZ_IMP_ORG_PROFILE_EXTN has this field populated but actual table HZ_ORGANIZATION_PROFILES do not have the right value imported.

EXPECTED BEHAVIOR
-----------------------
Data should be imported and displayed correctly in UI for custom fields.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create custom field for Organization profile.
2. Import value for custom field but UI not displaying the value.


Cause

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