看了下object属性: SELECT * FROM all_objects WHERE object_name LIKE 'JTF_RS_SALESREPS%';
APPS.JTF_RS_SALESREPS_MO_V是JTF.JTF_RS_SALESREPS的同义词,想是编译出的问题,开始重编: ALTER SYNONYM apps.JTF_RS_SALESREPS_MO_V COMPILE;
结果仍然没数据。。。上了metalink没找到结果。下午在一个帖子里无意中找到了类似的求助,解决方法很直接: DROP SYNONYM JTF_RS_SALESREPS_MO_V; CREATE SYNONYM JTF_RS_SALESREPS_MO_V FOR jtf.JTF_RS_SALESREPS;
declare v number(20); begin mo_global.init('ONT'); select salesrep_id into v from JTF_RS_SALESREPS_MO_V where rownum = 1; dbms_output.put_line(v); end; 能打印出数据,原来需要写一个mo_global.init('ONT');
begin mo_global.init('AR'); mo_global.set_policy_context('CUX','83'); end;
begin fnd_client_info.set_org_context (190); -- org_id end;
begin dbms_application_info.set_client_info (190); -- org_id end;
[code="java"]今天搞了整一个上午。R12 Demo VIS中查询JTF.JTF_RS_SALESREPS有数据,但是查APPS.JTF_RS_SALESREPS_MO_V死活没数据。看了下object属性:SELECT * FROM all_objects WHERE object_name LIKE 'JTF_RS_SALESREPS%';APPS....