Package中遇到“ORA-20001: APP-FND-02902:Multi-Org profile option is required. ”错误的处理方法

在各Responsibility中都会设定Multi-Org profile，可是在package中的时候，系统会无法抓到所属的Multi-Org profile，那么在操作有MOAC控制的时候就会报错“ORA-20001: APP-FND-02902:Multi-Org profile option is required. ”

 

处理方法：

在package body中加上一下代码即可就可以了。

 

fnd_global.apps_initialize(-1,50867,200);

mo_global.init('PO');

 

其中，-1为user_id (apps)，50867为responsibility_id,200为application_id，以上ID可用下面SQL查询

 

select application_id,responsibility_id,responsibility_name from fnd_responsibility_tl
where responsibility_name = 'Receivables Manager';