ORA-02070: database SALES does not support operator USERENV in this context

最新推荐文章于 2022-11-14 22:53:19 发布

weixin_30433075

最新推荐文章于 2022-11-14 22:53:19 发布

阅读量146

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/benio/archive/2009/12/25/1632073.html

版权

insert into erp_customer3＠erpsales
              (cust_acct_site_id,
               meaning,
               segment2,
               status,
               creation_date,
               created_by,
               last_update_date,
               last_updated_by)
              select csua.cust_acct_site_id,
                     flvv.meaning,
                     gcc.segment2,
                     csua.status,
                     csua.creation_date,
                     csua.created_by,
                     csua.last_update_date,
                     csua.last_updated_by
                from hz_cust_site_uses_all   csua,
                     fnd_lookup_values       flvv,
                     gl_code_combinations    gcc,
                     apps.fnd_flex_values_vl ffvv
               where csua.site_use_code = flvv.lookup_code
                 and flvv.lookup_type = 'SITE_USE_CODE'
                 and flvv.language = userenv('LANG')
                 and csua.gl_id_rev = gcc.code_combination_id(+)
                 and gcc.segment2 = ffvv.flex_value(+)
                 and ffvv.flex_value_set_id(+) = 1009628
                 and csua.status = 'A';

ERROR：ORA-02070: database SALES does not support operator USERENV in this context

临时解决办法：

　　and flvv.language = userenv('LANG')替换成and flvv.language = 'ZHS'

　　另外建立临时表fnd_flex_values_vl_tmp存储fnd_flex_values_vl的数据。

        delete from fnd_flex_values_vl_tmp;
        commit;

        --插入数据到临时表
        insert into fnd_flex_values_vl_tmp
        select * from apps.fnd_flex_values_vl;
        commit;

            insert into erp_customer3＠erpsales
              (cust_acct_site_id,
               meaning,
               segment2,
               status,
               creation_date,
               created_by,
               last_update_date,
               last_updated_by)
              select csua.cust_acct_site_id,
                     flvv.meaning,
                     gcc.segment2,
                     csua.status,
                     csua.creation_date,
                     csua.created_by,
                     csua.last_update_date,
                     csua.last_updated_by
                from hz_cust_site_uses_all   csua,
                     fnd_lookup_values       flvv,
                     gl_code_combinations    gcc,
                     fnd_flex_values_vl_tmp ffvv
               where csua.site_use_code = flvv.lookup_code
                 and flvv.lookup_type = 'SITE_USE_CODE'
                 and flvv.language = 'ZHS'

                 and csua.gl_id_rev = gcc.code_combination_id(+)
                 and gcc.segment2 = ffvv.flex_value(+)
                 and ffvv.flex_value_set_id(+) = 1009628
                 and csua.status = 'A';

转载于:https://www.cnblogs.com/benio/archive/2009/12/25/1632073.html