目前分類:INV:Inventory (16)

瀏覽方式: 標題列表 簡短摘要

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

image

Navigator : Setup > Flexfields > Key > Segments

image

2. Open [Segments] to see the value set

image

3. Check Uppercase Only (A-Z) checkbox

image

Done.

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Error message
image

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

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

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

 

文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

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

How to review pending transaction by inventory accounting period ?

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Workday Calendar

image

image

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

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

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

 

Pending Transactions

Table

Concurrent

Pending Material MTL_TRANSACTIONS_INTERFACE Process transaction interface
Pending Receiving RCV_TRANSACTIONS_INTERFACE Receiving Transactions Processor

SomebabyTina 發表在 痞客邦 留言(1) 人氣()

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

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

Responsibility : Inventory

Path : Accounting Close Cycle > Inventory Accounting Periods

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

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

SomebabyTina 發表在 痞客邦 留言(1) 人氣()

設置一個Subinventory Name = YOSUN

目前狀態為Inactive

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

如果你想把料號的屬性清空,你可以參考這篇文章
=== 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.
文章標籤

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

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

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

INV: Updateable item name

image

SomebabyTina 發表在 痞客邦 留言(0) 人氣()

一般庫存盤點的程序

  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

SomebabyTina 發表在 痞客邦 留言(1) 人氣()

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

image

SomebabyTina 發表在 痞客邦 留言(2) 人氣()