初始化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;

posted on 2026-04-03 14:31  miss斯娃  阅读(3)  评论(0)    收藏  举报