目前分類:INV:Inventory (15)

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

Error message
image

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

Solution

Resubmit all transaction line and save .

文章標籤

SomebabyTina 發表在 痞客邦 PIXNET 留言(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 發表在 痞客邦 PIXNET 留言(0) 人氣()

處理時間:每月最後一週,即可開始檢查有沒有異常的庫存交易需要處理
建議參考文件: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.

image

image 

You can use below sql to view each pending item ...

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

Workday Calendar

image

image

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(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

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;

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

 

Pending Transactions

Table

Concurrent

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

SomebabyTina 發表在 痞客邦 PIXNET 留言(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

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

Responsibility : Inventory

Path : Accounting Close Cycle > Inventory Accounting Periods

image

 

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(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

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

設置一個Subinventory Name = YOSUN

目前狀態為Inactive

image

測試項目: 是否可以收料進Inactive Subinventory?

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(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"

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

INV: Updateable item name

image


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

image

image

Enable Uppercase Only (A-Z)

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(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
  • Define Physical Inventory

Path: Counting > Physical Inventory>Physical Inventories

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

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

image


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

找更多相關文章與討論