How To Backorder Released to Warehouse Delivery Line Using API (Doc ID 2579996.1)

Goal

Solution

References

---

Applies to:

Oracle Inventory Management - Version 12.2.9 and later
Oracle Shipping Execution - Version 12.2.9 and later
Information in this document applies to any platform.

Goal

What are the steps required in order to use the Backorder API to backorder a delivery line which is released to warehouse ?

The example shown in this note is based on data in the Vision Demo database including Item, Organization, Sales Order, etc.

Solution

NOTE: In the images in the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Starting from 12.2.9 API is available to backorder a delivery line which is released to warehouse.

Sample script to call the API

DECLARE
  l_return_status VARCHAR2 (100);
  l_msg_count     NUMBER;
  l_msg_data      VARCHAR2 (2000);
  l_msg_index     NUMBER;

BEGIN

  INV_MO_BACKORDER_PUB.backorder
              ( p_api_version_number =>1.0 ,
                p_init_msg_list =>FND_API.G_TRUE ,
                p_commit =>FND_API.G_TRUE ,
                x_return_status =>l_return_status ,
                x_msg_count =>l_msg_count ,
                x_msg_data =>l_msg_data ,
                p_mo_order_line_id => &MoveOrderLineID );

  dbms_output.put_line ('Return Status is=>' ||l_return_status);

  IF l_return_status = fnd_api.g_ret_sts_success THEN
    dbms_output.put_line ('Successfully BackOrdered the Move Order Line' );
    COMMIT;

  ELSE
    dbms_output.put_line ('Could not able to Back Order Line Due to Following Reasons' );
    ROLLBACK;
    FOR j IN 1 .. l_msg_count
    LOOP
      fnd_msg_pub.get (p_msg_index => j, p_encoded => fnd_api.g_false, p_data => l_msg_data, p_msg_index_out => l_msg_index);
    END LOOP;
    dbms_output.put_line ('Error Message is=>' ||l_msg_data);
  END IF;

END;