Oracle eBS經驗分享

1. 請先到設定彈性欄位的地方

Navigator : Setup > Flexfields > Key > Segments

2. Open [Segments] to see the value set

3. Check Uppercase Only (A-Z) checkbox

Done.

Error message

Receiving Transaction Manager returned an error while processing the record with Interface Id 6541813. The error message returned is afptpput failed.

資料來源：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).

處理時間：每月最後一週，即可開始檢查有沒有異常的庫存交易需要處理
建議參考文件：Oracle Resolving Period Close Inventory Pending Transaction

How to review pending transaction by inventory accounting period ?

Workday Calendar

資料來源：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

沒有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

Responsibility : Inventory

Path : Accounting Close Cycle > Inventory Accounting Periods

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

設置一個Subinventory Name = YOSUN

目前狀態為Inactive

如果你想把料號的屬性清空，你可以參考這篇文章

=== 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.

有一個已經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'

INV: Updateable item name

一般庫存盤點的程序

1. 制定盤點時程計畫
2. 凍結庫存
3. 列印盤點清冊、盤點卡
4. 實際盤點
5. 輸入實際盤點數量
6. 盤點差異列印
7. 盤差盈虧調整
8. 庫存凍結解除
9. 盤點差異對策分析

Oracle Physical Inventory

1. Define physical inventory
2. Snapshot of on-hand quantities
3. Generate tags(列印盤點清冊、盤點卡)
4. Count Items(實際盤點)
5. Enter counts(輸入實際盤點數量)
6. Approve counts(盤差盈虧調整)
7. Run adjustment program

Resp: Inventory --> Setup -->Shipping Method