8 Replies Latest reply: May 23, 2014 5:07 AM by Jagadekara RSS

    Report not working properly according to the organization


      Hi guys,

      I have a problem in a customized report.

      i have developed a customized report which runs for all operating units.

      i have changed the operating unit mode to "single" so that users can see data only for their region.So i put this code in before parameter form "

      MO_GLOBAL.SET_POLICY_CONTEXT('S', sys_context('multi_org2','current_org_id'));"

      and i have used fnd.user_exit(userinit) and fnd.user_exit(userexit in before report and after report triggers.

      Even though i put those the report shows diff region data.

      Please help me

      Thanks in advance.