My Oracle Support Banner

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:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
Cause
Solution
References


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