首页 > Windows开发 > 详细

How To Transact Move Order Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API

时间:2014-11-05 12:59:33      阅读:2187      评论:0      收藏:0      [点我收藏+]

In this Document

Goal
  Solution
  Sample Code:
  Steps:
  FAQ
  References

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

This document includes 11.5.10, 12.0.1 and later


GOAL

The purpose of this document is to provide a demonstration showing how Move Orders can be transacted using APIs. The demonstration uses the API  INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm to transact Move Orders.

There is a document which has sample code for test purposes.

SOLUTION

Sample Code:

Please review the below instructions and sample code document. The API call looks something like this using INV_PICK_WAVE_PICK_CONFIRM_PUB from INVPCPWB.pls. See the sample code for a complete example but here is a snippet of the call:

...
INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm
(
p_api_version_number => l_api_version
, p_init_msg_list => l_init_msg_list
, p_commit => l_commit
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_move_order_type => l_move_order_type
, p_transaction_mode => l_transaction_mode
, p_trolin_tbl => l_trolin_tbl
, p_mold_tbl => l_mold_tbl
, x_mmtt_tbl => x_mmtt_tbl
, x_trolin_tbl => x_trolin_tbl
, p_transaction_date => l_transaction_date
);
...

 

Note: In 11.5.9, the last parameter (transaction date) was added with Patch 3438094 in version INVPCPWB.pls 115.47.11590.6.

 

Steps:

1) Create a Move Order and approve it.
2) Query for the move order and allocate quantity for the Move Order lines
3) Run the API to transact material from the allocated subinventory with move order line id as the parameter.

Move Order Type:

Value Move Order Type
1 Requisition
2 Replenishment
3 Pick Wave
4 Receipt
5 Manufacturing Component Pick
6 Put Away

FAQ

#1) How to transact partial qty on a move order line ?

Steps: 
1) Create , book and release the sales order with Auto Allocate = Yes, Auto Pick Confirm = No. 
2) Go to Transact Move Orders, Query for the move order, Click on View/ Update Allocations. 
3) Reduce the allocation qty, and click save. (Note that API INV_REPLPENISH_DETAIL_PUB.Line_Details_Pub does have a limitation where it cannot allocate quantity lesser than requested quantity, so, this can be done only from forms) 
4) Now transact the move order using the same API code as before.
5) See that the reduced qty on the move order line is transacted, and rest on the order line is back ordered.

This needs to be released again, as the current move order would be closed after its transacted.
This is same as front-end functionality, when clicking on ‘Transact‘ button it will try to transact all the lines that are allocated on that form.

Note: If requested_qty = detailed_qty on the Move Order Line, the API would transact all the detailed_qty. If the detailed_qty < requested_qty, only detailed_qty will be transacted, and the rest would be back-ordered.   

#2) Is under-picking supported using API ? 


Under picking is not supported through the api. It can only be done manually via the Transact move orders form. 

#3) Can you split allocations using API ?

The public API INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM() is only meant
for transacting allocation against the move order. ‘Splitting Allocation‘ kind of functionality through
public API is not supported.

#4) After allocating user-defined serials for a lot-serial controlled item following Note 1332302.1 seeing error "Lot-serial quantity does not match transaction quantity" error while transacting using API ?

Please review if the lot and serial information is correct on the allocation from Transact Move Orders form -> Query for the move order -> Click on View/ Update Allocations. It is more likeky that the lot - serial - subinventory - locator information may be incorrect on the allocation. Please correct the same and then, run the transact API again.

REFERENCES

NOTE:729261.1 - How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header API [Video] ?
NOTE:729265.1 - How To Process Move Orders (Create Header and Lines) Using INV_MOVE_ORDER_PUB.Process_Move_Order API [Video] ?
NOTE:729513.1 - How to use APIs for Inventory / Product Information Management [Video] ?
NOTE:729998.1 - Oracle Inventory Management Application Program Interface ( APIs)
NOTE:783521.1 - How to Allocate Move Orders using INV_REPLENISH_DETAIL_PUB.line_details_pub API ?
NOTE:729263.1 - How To Create Move Order Lines Using INV_MOVE_ORDER_PUB.Create_Move_Order_Lines API [Video] ?
NOTE:1900798.1 - INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm Return Status Code U
bubuko.com,布布扣
bubuko.com,布布扣

How To Transact Move Order Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API

原文:http://blog.csdn.net/cai_xingyun/article/details/40821309

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!