In this Document
APPLIES TO:
Oracle Inventory Management - Version 12.0.0 and laterInformation in this document applies to any platform.
This document includes all versions R12.x.x and later.
***Checked for relevance on 22-Oct-2013***
GOAL
The document lists references to notes that show how to use public APIs provided and examples of sample code that show the use of Inventory APIs.
SOLUTION
How to use APIs: This demonstration walks the user through the API specifics, creating the PL/SQL procedure for using an API and also debugging guidelines.
| Note | Title |
|---|---|
| How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header API [Video] ? | |
| How To Create Move Order Lines Using INV_MOVE_ORDER_PUB.Create_Move_Order_Lines API [Video] ? | |
| How To Process (Create) Move Orders (Headers and Lines) Using INV_MOVE_ORDER_PUB.Process_Move_Order API [Video] ? | |
| How To Create Reservations for Items Using INV_RESERVATION_PUB.Create_Reservation API [Video] ? | |
| How To Relieve Reservations For Items Using INV_RESERVATION_PUB.Relieve_Reservation API [Video] ? | |
| How To Update Reservations For Items Using INV_RESERVATION_PUB.Update_Reservation API [Video] ? | |
| How to Allocate Move Orders using INV_REPLENISH_DETAIL_PUB.line_details_pub API [Video] ? | |
| How To Transact Move Order Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API [Video] ? | |
| How to Allocate "User-Defined" serial numbers using a Custom Hook INV_DETAIL_SERIAL_PUB.Get_User_Serial_Numbers at Pick Release Using Inventory Allocation API [Video] ? | |
| How to Create Item Based UOM Conversions using API INV_CONVERT.Create_Uom_Conversion ? | |
| How to Change The Inventory Onhand Status Using INV_MATERIAL_STATUS_PUB.Update_Status API ? | |
| Check Onhand With PL/SQL: Review Stock Picture For An Item in a Given Organization / Subinventory [Video] (INV_QUANTITY_TREE_PUB.Query_Quantities) | |
| How to Create a Locator using API INV_LOC_WMS_PUB.CREATE_LOCATOR ? |
REFERENCES
- How to use APIs for Inventory / Product Information Management [Video] ?- How to Enable Trace or Debug for APIs executed as SQL Script Outside of the Applications ? [Video]