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


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
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




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.