My Oracle Support Banner

Lead Import Channel Field is Not Populating With Data Imported From As_import_interface (Doc ID 1110315.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle Leads Management - Version 12.0 and later
Information in this document applies to any platform.


On : R12 , when importing leads into Sales , via Oracle Marketing ,  the am_import_interface table shows Sales channel = Marketing Indirect.

When the record appears in Sales , Sales channel = Marketing Direct.
The values appear to be defaulting from profile settings.

Expect to get the same sales channel value 'Marketing Indirect'  imported in Sales .

The issue can be reproduced at will with the following steps:

> Login as Oracle Marketing Super User.
> Audience Dashboard > Import > Import leads.
> Enter the import details data .
> Enter Import Mapping date, using the 'Sales_channel_code' column .
> check the am_import_interface table is showing channel = Marketing Indirect.
> query the same lead in Sales , and check the Sales channel = Marketing Direct


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

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