how to set org_id for a concurrent report

[kartikey_becs]

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

[siva sankar]

Hi,

Please try this...

BEGIN

FND_CLIENT_INFO.SET_ORG_CONTEXT('ORG_ID');

END

If you have any queries please let me know..

[kartikey_becs]

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

[siva sankar]

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

[amitm_66]

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

[sankarch]

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;