Monday, October 23, 2017

Does Order Import Concurrent Program Perform Validation on Closed Sales Orders?

Does Order Import perform any data validation on the closed orders? 

Sales Orders are being imported into Order Management via the Order Import Open Interface.  These orders exist in a legacy system and are being imported in a closed status for historical purposes.

Order Import allows Closed Sales Orders to be imported into Order Management by setting the CLOSED_FLAG attribute on the headers OE_HEADERS_IFACE_ALL and lines OE_LINES_IFACE_ALL interface tables to 'Y'.  These sales orders undergo the same validation based on the setting of the BOOKED_FLAG attribute in the OE_HEADERS_IFACE_ALL table.  If BOOKED_FLAG is set to 'Y', then the Closed Sales Order undergoes the same data validation as for an open Booked Order.  That is, all the fields required for booking must be populated on the Closed Order.  If the BOOKED_FLAG is set to 'N', then only minimal validation is done.


No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)