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