目前分類:INV:Inventory (16)
- Aug 03 Sat 2019 19:09
[How To] 如何設定料號只能大寫? Uppercase Item Name
- Dec 25 Tue 2012 12:15
{Error} Open interface error : afptpput failed
Receiving Transaction Manager returned an error while processing the record with Interface Id 6541813. The error message returned is afptpput failed.
- Aug 28 Tue 2012 11:10
{Period Close} Resolving Pending Receiving Transactions
資料來源: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
{SQL} For Period Close Inventory Pending Transaction Validation
處理時間:每月最後一週,即可開始檢查有沒有異常的庫存交易需要處理
建議參考文件:Oracle Resolving Period Close Inventory Pending Transaction
How to review pending transaction by inventory accounting period ?
- Aug 16 Tue 2011 17:29
How to set calendar -week Tue/Thr on , others off
- Oct 01 Fri 2010 16:50
[INV] Get available onhand qty API
資料來源:http://erpschools.com/Apps/oracle-applications/scripts/Supply-Chain-Management/Inventory/Get-On-Hand-Quantities-through-API/index.aspx#
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
{INV} Transaction Process Program
Pending Transactions |
Table |
Concurrent |
Pending Material | MTL_TRANSACTIONS_INTERFACE | Process transaction interface |
Pending Receiving | RCV_TRANSACTIONS_INTERFACE | Receiving Transactions Processor |
- Aug 04 Wed 2010 14:41
Subinventory transfer from different cost-group
沒有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
How to open inventory accounting period
- Jul 21 Wed 2010 12:31
Direct Inter-Organization Transfer Accounting
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:
Account
Organization
Debit
Credit
Inter-Organization Receivable
Sending
XX
Org. Inventory Valuation accounts
Sending
XX
Org. Inventory Valuation accounts
Receiving
XX
Inter-Organization Payable
Receiving
XX
- May 18 Tue 2010 12:04
{TEST} Inactive Subinventory
- Dec 22 Tue 2009 10:00
如何透過interface清空Item屬性值
如果你想把料號的屬性清空,你可以參考這篇文章
=== Oracle Inventory ===
(ERP Version : 11.5.10.2)
Goal
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
{Setup} Auto Delete Allocations at Move Order Cancel
有一個已經Allocate的Move Order的Sales Order Line被Cancel, 但Move Order Line卻未被Close, 造成Reserve住庫存, 致使新的Move Order無法順利執行Allocate
解決方法,可參考Notes:338740.1,有一設定值可使用
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
{INV} 可以修改Item Segment 的Profile
- Sep 19 Sat 2009 23:00
{Learn} Physical Inventory 實體盤存
一般庫存盤點的程序
- 制定盤點時程計畫
- 凍結庫存
- 列印盤點清冊、盤點卡
- 實際盤點
- 輸入實際盤點數量
- 盤點差異列印
- 盤差盈虧調整
- 庫存凍結解除
- 盤點差異對策分析
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
{How To} Create Ship Method