8.1.1 List Import Custom Columns

(Doc ID 872372.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1 [21039] and later
Information in this document applies to any platform.
***Checked for relevance on 26-Mar-2012***


Symptoms

Custom fields needs to be imported using the new List Import function for Siebel Marketing 8.1.1 SIA.

Steps detailed in "How to extend mappable columns to add custom fields in Siebel 8.1.1 List Import (Doc ID 842862.1)" have been followed.

Ten custom fields on the Contact BC were added.

AMW Generic List Import 1
AMW Generic List Import 2
AMW Generic List Import 3
AMW Generic List Import 4
AMW Generic List Import 5
AMW Generic List Import 6
AMW Generic List Import 7
AMW Generic List Import 8
AMW Generic List Import 9
AMW Generic List Import 10

These columns are mapped to the S_CONTACT_X table.

This works for list import in v8.0.

For 8.1.1, the values are stored in the staging S_CONTACT_IMPT table. However, they are not populated to S_CONTACT_X after import.

It is confirmed that other fields (e.g. Email Address) are updating correctly to the Contact BC.

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