- Dec 25 Tue 2012 12:15
- Aug 28 Tue 2012 11:10
資料來源：Oracle Pending Transactions Guide page 21 of 32.
In resolving Pending Receiving Transactions the status and quantity received of the actual purchase order of the receiving transaction should be reviewed. If after reviewing the Purchase Order if the status is closed or complete and the purchase order quantity is equal to the quantity received then most likely the Pending Receiving transaction is a duplicate. Duplicate transactions can be deleted through the ‘Transaction Status Summary’ screen by clicking on the transaction line and then clicking on the delete icon.
如果資料已經存在RCV_Transactions , 代表資料重複了，所以可以從Pending receiving 畫面上的Delete鍵直接刪除。
Receiving transactions are processed through RCV_TRANSACTiON_INTERFACE table by submitting the ‘Receiving Transaction Processor’ (short name RVCTP).
- Jul 27 Fri 2012 15:45
建議參考文件：Oracle Resolving Period Close Inventory Pending Transaction
How to review pending transaction by inventory accounting period ?
Responsibility : Inventory super user
Navigator : Accounting Close Cycle > Inventory Accounting Periods
==> Choose the organization you want to view.
You can use below sql to view each pending item ...
- Aug 16 Tue 2011 17:29
- Oct 01 Fri 2010 16:50
Get On Hand Quantities through API
This script can be used to get the below quantities. 1. On-hand Quantity 2. Available to Reserve 3. Quantity Reserved 4. Quantity Suggested 5. Available to Transact 6. Available to Reserve You can also get the On-hand quantities from the table mtl_onhand_quantities
DECLARE x_return_status VARCHAR2 (50); x_msg_count VARCHAR2 (50); x_msg_data VARCHAR2 (50); v_item_id NUMBER; v_org_id NUMBER; v_qoh NUMBER; v_rqoh NUMBER; v_atr NUMBER; v_att NUMBER; v_qr NUMBER; v_qs NUMBER; v_lot_control_code BOOLEAN; v_serial_control_code BOOLEAN; BEGIN -- Set the variable values v_item_id := 12758; v_org_id := 91; v_qoh := NULL; v_rqoh := NULL; v_atr := NULL; v_lot_control_code := FALSE; v_serial_control_code := FALSE; -- Set the org context fnd_client_info.set_org_context (1); -- Call API inv_quantity_tree_pub.query_quantities (p_api_version_number = 1.0 , p_init_msg_lst ='F' , x_return_status =x_return_status , x_msg_count =x_msg_count , x_msg_data =x_msg_data , p_organization_id =v_org_id , p_inventory_item_id =v_item_id , p_tree_mode =apps.inv_quantity_tree_pub.g_transaction_mode -- or 3 , p_is_revision_control =FALSE , p_is_lot_control =v_lot_control_code-- is_lot_control, , p_is_serial_control =v_serial_control_code , p_revision =NULL -- p_revision, , p_lot_number =NULL -- p_lot_number, , p_lot_expiration_date =SYSDATE , p_subinventory_code =NULL -- p_subinventory_code, , p_locator_id =NULL -- p_locator_id, -- p_cost_group_id =NULL, -- cg_id, , p_onhand_source =3 , x_qoh =v_qoh -- Quantity on-hand , x_rqoh =v_rqoh --reservable quantity on-hand , x_qr =v_qr , x_qs =v_qs , x_att =v_att -- available to transact , x_atr =v_atr -- available to reserve ); DBMS_OUTPUT.put_line ('On-Hand Quantity: ' || v_qoh); DBMS_OUTPUT.put_line ('Available to reserve: ' || v_atr); DBMS_OUTPUT.put_line ('Quantity Reserved: ' || v_qr); DBMS_OUTPUT.put_line ('Quantity Suggested: ' || v_qs); DBMS_OUTPUT.put_line ('Available to Transact: ' || v_att); DBMS_OUTPUT.put_line ('Available to Reserve: ' || v_atr); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line ('ERROR: ' || SQLERRM); END;
- Sep 10 Fri 2010 09:22
|Pending Material||MTL_TRANSACTIONS_INTERFACE||Process transaction interface|
|Pending Receiving||RCV_TRANSACTIONS_INTERFACE||Receiving Transactions Processor|
- Aug 04 Wed 2010 14:41
沒有On WMS時，不同的Cost Group 可以做Subinventory Transfer; WMS on了以後，就不行了。
（參Oracle Warehouse Managment User Guide Page-132)
Comingle Cost Groups - The material being put away has one cost group while
the destination has material of another cost group. There are no characteristics
(revision, lot, serial, or license plate) which would differentiate these two groups
- Aug 03 Tue 2010 17:14
- Jul 21 Wed 2010 12:31
You use the Interorganization Transfer window for direct transfers. When your the interorganization relationship is set to direct transfer in the Shipping Networks window, an issue and receipt transaction are performed in one step. In addition, each organization may be in a different set of books and even in a different currency. The accounting entries created are as follows:
- May 18 Tue 2010 12:04
- Dec 07 Mon 2009 13:22
有一個已經Allocate的Move Order的Sales Order Line被Cancel, 但Move Order Line卻未被Close, 造成Reserve住庫存, 致使新的Move Order無法順利執行Allocate
Go into the responsibility: Inventory
Goto Inventory > Setup > Organization > Parameters
Goto the first tab "Inventory Parameters"
- Nov 16 Mon 2009 19:32
- Sep 19 Sat 2009 23:00
Oracle Physical Inventory
- Define physical inventory
- Snapshot of on-hand quantities
- Generate tags(列印盤點清冊、盤點卡)
- Count Items(實際盤點)
- Enter counts(輸入實際盤點數量)
- Approve counts(盤差盈虧調整)
- Run adjustment program
- Define Physical Inventory
Path: Counting > Physical Inventory>Physical Inventories
- Dec 10 Wed 2008 09:25