今天的系統在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就可以了。