Tuesday, August 21, 2012

Copy existing sales order through Open interface

Copy an existing order by importing it through Open interface tables & Import orders program.

Provide the order number to copy & the order source id in the below code snippet.

DECLARE
   l_return_status       VARCHAR2 (1);
   l_order_number_from   NUMBER := <Order_Number1>;
   l_order_source_id     NUMBER := <Order_Source_ID>;

BEGIN
   oe_debug_pub.debug_on;
   oe_debug_pub.initialize;
   oe_debug_pub.add ('Before Calling oe_inf_populate_pub.populate_interfacel', 1);
   oe_inf_populate_pub.populate_interface (
      p_api_version_number   => 1.0,
      x_return_status        => l_return_status,
      p_order_number_from    => l_order_number_from,
      p_order_source_id      => l_order_source_id);
   oe_debug_pub.add ('After Calling oe_inf_populate_pub.populate_interface', 1);
END;

After the running the above piece of code, run the standard order import program from application with the ORIG_SYS_DOCUMENT_REF=<Order_Number1>