初始化OU

BEGIN
Fnd_Global.Apps_Initialize(User_Id => 0, Resp_Id => 50722, Resp_Appl_Id => 222);
Mo_Global.Init('SQLAP');
Mo_Global.Set_Policy_Context(p_Access_Mode => 'M', p_Org_Id => 81);
END

少加了代码： Mo_Global.Init('SQLAP'); --初始化Multi Org，临时表mo_glob_org_access_tmp有数据
Mo_Global.Set_Policy_Context(p_Access_Mode => 'S', p_Org_Id => 81); --设置Org访问模式，S为单OU访问，M为多OU访问，A为所有OU访问

SELECT * FROM hr_operating_units;

SELECT * FROM FND_RESPONSIBILITY_TL
WHERE RESPONSIBILITY_ID = 50722;