目前日期文章:201008 (7)

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

image

Error log: image

Error Message
msg_buffer ==> Inventory Interface could not process some of the lines in the batch as they are locked by another process.
W:Inventory Interface could not process some of the lines in the batch as they are locked by another process.
 
Solution

確認是否有相同的Transaction Data 存在MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_TRANSACTIONS_INTERFACE,理論上同一筆Material Transaction 資料不會同時出現兩個Tables,如果有的話就有問題,Oracle建議刪除MTL_TRANSACTIONS_INTERFACE的資料。

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

Personalizations are stored in tables, separate
from the forms they alter:

FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_PROP_LIST

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

==注意事項==

Necessary Coding For Views
• Call code in your ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK
triggers to access the base table instead of the view
• Create ROWID as the first column in your view, and alias it to ROW_ID
• Use the ROWID of the main entity table in your view

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

沒有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) 人氣()

Please verify your setting as below picture.

Uncheck []Close Other Forms, then it should be ok now.

image


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

Responsibility : Inventory

Path : Accounting Close Cycle > Inventory Accounting Periods

image

 

image

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

Responsibility : System Administrator

Path : Install > Territories

image

建議如果要新增新的國家,還是先上Oracle Metalink找找看有沒有path可以上。

避免Code取的不一樣,進而在相關貿易文件上出差錯。

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

找更多相關文章與討論