Monday, October 23, 2017

How To Identify If A Sales Order Is Created Via the Form or Order Import?

By checking the ORDER_SOURCE_ID at the header level(OE_ORDER_HEADERS_ALL table) we can come to know whether the order is entered via the Sales Order Form or imported via the Order Import Concurrent Process.

If the order is created online the value for order_source_id should be '0'.


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)