Order Import Submitted Without Operating Unit (OU): Error Validation Failed For The Field - Bill To (Doc ID 1999239.1)

Last updated on AUGUST 17, 2020

Applies to:

Symptoms

On : 12.1.3 version, Transaction Entry

When attempting to run Order Import without entering an OU, and there are orders for more than 1 OU in the Interface tables,
the following error occurs.h

ERROR
Order Number :XXXXXX Line Number :
Message :Validation failed for the field - Bill To Contact

Order Number :XXXXXX Line Number :
Message :Validation failed for the field - Ship To Contact

STEPS
1. Order Management Responsibility
2. Populate the Order Import tables with 2 orders, one for MX OU and one for US OU:
Mexico OU - OSR - DEMANDWARE REGULAR ORDERS - MX-7239090
US OU - OSR - DEMANDWARE REGULAR ORDERS - US-7238086
  (data is captured in the IF tables in 2 files , one for MX Order and another one for US order, file names have OSR value.

3. Run Order import.
4. Results:
Message :Column location must have a value.
Message :Validation failed for the field - Bill To Contact
Message :Validation failed for the field - Ship To Contact

Work-around is to:
1. clear the req ID & error flag
2. Run Order Import again for the US order
3. It will then import without any errors.

Cause

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