My Oracle Support Banner

Cannot Import List Into Audience Workbench Record Shows Error Column Country Must Have A Value (Doc ID 416158.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Marketing - Version 12.0 and later
Information in this document applies to any platform.
amsListImpOverMain.jsp, amsListImpLogMain.jsp, AMSILHZC

Symptoms

Cannot import list into Audience Workbench. The status of the list goes from Staged to Error. The record error is Column country must have a value.  Log file shows AMSILHZC ----- no records to process ZERO not submitting any child request.

Steps to Reproduce
1. Responsibility: Audience Workbench
2. Navigation: Dashboard > Import
3. Click create button
4. Enter details to import list then click finish
5. Status of list in Import Overview goes from staged to Error
6. Click on the list name to get Import details, this will show you how many records are in error.
7. Click on the Number of Error records hyperlink
8. Error text: Column country must have a value


Log file Extract
ImportCSVDocument::l_bdDocumentId::37111 m_FileImportFile.getAbsolutePath()::/<DIR>/logs/ora/10.1.3/j2ee/oacore/imports/1172011706444/Book1.csv m_strEncoding::ISO8859_1
.
.
before Create_Customer
after Create_Customer
after Create_Customer x_return_status = E
after Create_Customer x_msg_count = 1
after Create_Customer x_msg_data = Column country must have a value.
before FETCH ..................
TCA import Program(-)
IN import to HZ Request Id: 4349226
l_parent_request_id = 4349226
Stop processing size = 0
Restoring g_prof HZ_EXECUTE_API_CALLOUTS: Y
Start Business event : oracle.apps.ams.list.ListImportPostEvent
End Business event : oracle.apps.ams.list.ListImportPostEvent
Total Number of records not processed: 0
AMSILHZC ----- no records to process ZERO not submittng any child request

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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