EBS po.plsql.PO_RELGEN_PKG.CREATE_RELEASES code: -20001

今天的系統在CREATE RELEASES時出現error,但是PO卻有成功建立,log只有一行訊息:
po.plsql.PO_RELGEN_PKG.CREATE_RELEASES.100 exception; SQL code: -20001

看不出來是什麼原因造成error,從Google查也查不出什麼結果,只好從Metalink找看看有沒有相關訊息。
Metalink上文檔 ID 271864.1 提到Inventory Organization missing in Receiving Options,
並提供一段SQL檢查沒有設定Receiving Parameter的organization id(SQL我有修改過):
select organization_id,name from HR_ORGANIZATION_UNITS_V
    where organization_id in (select h.organization_id
    from APPS.HR_ORGANIZATION_INFORMATION_V h
    where h.ORG_INFORMATION1_MEANING = 'Inventory Organization'
      and not exists ( select 1 from rcv_parameters r
           where r.organization_id = h.organization_id) );
 
檢查的結果有一個最近剛剛新增的organization沒有設定到Receiving Parameter,
到Setup->Organizations->Organizations內去設定Receiving Information就可以了。


Oracle Data Gurad Archive Gap