- Aug 03 Sat 2019 19:09
- 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
- 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
- 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
of material. The system does not allow cost group commingling where the cost
group cannot be identified by some physical characteristic
- 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:
Org. Inventory Valuation accounts
Org. Inventory Valuation accounts
- May 18 Tue 2010 12:04
- Dec 22 Tue 2009 10:00
=== Oracle Inventory ===
(ERP Version : 18.104.22.168)
Updating Item Attributes to NULL
The method to update these columns to NULL is to use the following values:
· for Numeric fields: insert -999999
· for Character fields: insert '!'
· for Date fields: the above list does not include any updateable date fields.
- 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"
Select checkbox 'Auto Delete Allocations at Move Order Cancel'
- 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
- Dec 10 Wed 2008 09:25