Page 1 of 1

Script To Populate Order Import Interface Tables F

Posted: Fri Jun 20, 2008 12:06 am
by ahmadbilal
OEOIMP: Script To Populate Order Import Interface Tables From Existing Sales Order

Doc ID: 436215.1
Last Revision Date: 05-JUL-2007
Status: PUBLISHED

This script may be used to populate the Order Import interface tables using data from an existing sales order. This is useful for users who are not familiar with how to populate the interface tables for different import scenarios (like ATO models, discounts etc), or in cases where the order import fails but a similar order can be created via the Sales Order form. The script will use the existing sales order data in the base tables (oe_order_headers_all, oe_order_lines_all, oe_price_adjustments, oe_payments, oe_sales_credits, oe_lot_serial_numbers) to populate the interface tables, effectively creating a mirror image of the existing sales order. The interface tables populated are:

oe_headers_iface_all, oe_lines_iface_all, oe_price_adjs_iface_all, oe_payments_interface, oe_credits_iface_all, oe_lotserials_iface_all