Oracle EBS: 客製intercompany中transfer price規則

針對此需求, 要修改:

MTL_INTERCOMPANY_INVOICES.get_transfer_price


Ref:
1.How to Customize Intercompany Transfer Price and Derive Based on Average Cost
http://raghu-oracleapps.blogspot.com/2010/04/how-to-customize-intercompany-transfer.html

2.Transfer Price
http://www.oracleug.com/user-guide/general-ledger/transfer-price

Oracle EBS: Concurrent program returned no reason for failure

狀況:
1.concurrent program的status為Error
2.View Log中只有列出start的日期時間, 資訊不完整
3.View Details中, Completion Text的訊息為Concurrent program returned no reason for failure


檢查方式:
Concurrent
 ->Manager
  -> Administer
   -> Standard Manager
    -> Processes
     -> Internal Manager Log

依request id搜尋, 找到相符的資料為:

Found running request xxxxxx attached to dead manager process.
Setting request status to completed.

Found dead process: spid=(2734), cpid=(4737129), ORA pid=(114), manager=(0/11312)


原因: 進行控制的manager沒有在所有處理都完成後才停止(shut down)


避免此問題的方法:
1.要到所有處理都完成後, 再停止 internal manager
2.若有manager在還有處理動作進行時被停止, 而且internal manager已啟動, 可在OAM中執行Concurrent Manager Recovery


Ref:
1.Concurrent program returned no reason for failure
http://oracleexpertsolutions.blogspot.com/2013/01/concurrent-program-returned-no-reason.html

2.Concurrent program returned no reason for failure
https://oralinx.wordpress.com/2011/09/29/concurrent-program/

3.Why Are Dead Process Found In The Standard Manager Log File? [ID 246584.1]

Oracle EBS: fnd_lobs的檔案來源

select fad.seq_num, fad.entity_name, fad.pk1_value, fad.pk2_value
  from fnd_attached_documents fad,
       fnd_documents fd
       fnd_lobs fl
 where fad.document_id = fd.document_id
   and fd.media_id = fl.file_id


Ref:

1.Oracle Apps: Helpful Queries on FND Attachments tables and sample code to extract attachments
http://johnytips.blogspot.com/2016/01/oracle-apps-helpful-queries-on-fnd.html

2.EBS Attachements表结构
https://blog.csdn.net/cunxiyuan108/article/details/6446698