处理物料搬运单使用INV_MOVE_ORDER_PUB.Process_Move_Order API

How To Process Move Orders (Create Header and Lines) Using INV_MOVE_ORDER_PUB.Process_Move_Order API ?

Goal

如何使用 API - INV_MOVE_ORDER_PUB.Process_Move_Order API 处理移动订单。该 API 使用单个 API 创建移动订单标题和行数

Solution

NOTE: In the images below and/or 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.

1. Code Snippet

 

     INV_MOVE_ORDER_PUB.Process_Move_Order(

                   P_API_VERSION_NUMBER   => l_api_version

                ,  P_INIT_MSG_LIST        => l_init_msg_list

                ,  P_RETURN_VALUES        => l_return_values

                ,  P_COMMIT               => l_commit

                ,  X_RETURN_STATUS        => x_return_status

                ,  X_MSG_COUNT            => x_msg_count

                ,  X_MSG_DATA             => x_msg_data

                ,  P_TROHDR_REC           => l_trohdr_rec

                ,  P_TROHDR_VAL_REC       => l_trohdr_val_rec

                ,  P_TROLIN_TBL           => l_trolin_tbl

                ,  P_TROLIN_VAL_TBL       => l_trolin_val_tbl

                ,  X_TROHDR_REC           => x_trohdr_rec

                ,  X_TROHDR_VAL_REC       => x_trohdr_val_rec

                ,  X_TROLIN_TBL           => x_trolin_tbl

                ,  X_TROLIN_VAL_TBL       => x_trolin_val_tbl          

        );

2. Sample code

Please review sample code document - Process Move Orders Sample API for the sample API Code (Note: The script was modified to allow substitution of values directly and avoid the custom table creation)

3. FAQ

1. How to provide secondary quantity, secondary UOM for move order line using API ?

-- Include below 4 input valies to create move order using secondary qty

l_trolin_tbl(l_row_cnt).quantity := 1000;             -- secondary qty

l_trolin_tbl(l_row_cnt).uom_code := 'L';              -- secondary uom

l_trolin_tbl(l_row_cnt).secondary_quantity := 1000;   -- secondary qty

l_trolin_tbl(l_row_cnt).secondary_uom := 'L';         -- secondary uom