1.创建表时,对_ALL表创建同义词
-- Create Multi Org Synonym
CREATE OR REPLACE SYNONYM CUX_WF_DEF_HEADER FOR CUX.CUX_WF_DEF_HEADER_ALL;
2.对表添加VPD
-- Create Multi Org VPD Policy
BEGIN
dbms_rls.add_policy(object_name => 'CUX_WF_DEF_HEADER',
policy_name => 'ORG_SEC',
policy_function => 'MO_GLOBAL.ORG_SECURITY',
policy_type => dbms_rls.shared_context_sensitive);
END;
删除
dbms_rls.drop_policy(object_schema => 'APPS',
object_name => 'CUX_WF_DEF_HEADER',
policy_name => 'ORG_SEC');
3.对CUX应用进行注册
BEGIN
fnd_mo_product_init_pkg.register_application
(p_appl_short_name => 'CUX',
p_owner &#