1 person found this helpful
Do you have org_id parameter in your report?
i have used fnd.user_exit(userinit) and fnd.user_exit(userexit in before report and after report triggers.
also use SRW.USER_EXIT('FND SRWINIT'); in before parameter form trigger
and SRW.USER_EXIT('FND SRWEXIT'); in after report trigger.
yes i do have org id as parameter and in my before report i am calling
:P_ORG_ID := FND_PROFILE.VALUE('ORG_ID') ;
Then try this way....
ID TRIED THAT BUT THIS IS FROM HRMS NOT FINANCIALS.
ID TRIED THAT BUT THIS IS FROM HRMS NOT FINANCIALS
I didn't get you.
If it is HRMS, so what?
What exactly you are facing now?
The report works perfect when the regions want to see their region data and when they try to see other regions data it doesnot allow.
so itw well and fine but my problem is there is head office where they should should their region and other region data also. their i am struggling .
the resp MO% in profile options has been set according to the regions.
ty guys. i sorted it out.
thanks for the suggestions. much appriciated.
How you resolved this issue?
post here, that would help others...