ERPstuff - Oracle EBS Community

Hi
I hv created a sql*plus base concurrent report,registered it and it is working fine.I want to do a modification that is from one responsibility suppose from PA US superuser i want to get details of UK+US clients through concurrent report(org_id hv already set for profile).Right now i can only access details of US client .I m also using view in this report alsoand using 11i
so plz give me some solution
thanks

Hi,

Please try this...

BEGIN

FND_CLIENT_INFO.SET_ORG_CONTEXT('ORG_ID');

END

If you have any queries please let me know..

hi siva,
Plz tell can I use this procedure directlly in my sql programe and just simple register it with apps.
or i hv to do it differently.
thanks

Hi,

Please execute in SQL promt or TOAD.
SQL>

BEGIN

FND_CLIENT_INFO.SET_ORG_CONTEXT('ORG_ID');

END;
/
SQL>

If any queries please let me know

R u trying to make the rdf report multi org?
in that case u need to follow different concept.
Let me know the answer for my question tehn i would provide you the logic

Hi,

Please set the query in sql prompt or report developer in the before parameter from or after parameter form,

This is Support oracle apps11i

begin
fnd_client_info.set_org_context(org_id);
end;


This is support the sql prompt
begin
dbms_application_info.set_client_info(org_id);
end;