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 and later
Oracle Fusion Customer Center - Version and later
Information in this document applies to any platform.


On : version, Accounts, Contacts, Households

 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

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.

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

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.


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