2 Replies Latest reply: Nov 20, 2012 7:52 PM by 973049 RSS

    Secured Synonym

    973049
      Hi,

      We are undergoing a migration to r12 from 11i. I am not sure on how to handle the Secured Synonyms.

      There is a custom report whose parameter is based out of 'PO_REQUISITION_HEADERS' which is a view in 11i, it runs fine there. But in r12 it is a secured synonym. So when I click on the parameter (in R12) I get an error that there are no values. If it was in code (sql etc) I could have set the Mo_Global, but in the parameter, w can't do that.

      if I use the base table _ALL, I get multiple rows for the same Req# for different OUs.
      I have also tried to add fnd_profile.value ('org_id') in the where clause of the VS, still same error.

      Any one has resolved such an issue earlier? It is a table type VS.

      Thanks

      Edited by: 970046 on Nov 20, 2012 1:38 AM

      Edited by: 970046 on Nov 20, 2012 1:46 AM
        • 1. Re: Secured Synonym
          AlexAnd
          add your concurrent program for use multiorg mode as
          System Administration -> Concurrent -> Programs -> find by short name -> Update -> tab Request -> Operating Unit Mode -> Multiple
          • 2. Re: Secured Synonym
            973049
            Thanks Alex.

            Though you mentioned, I was looking at System Adminitrat*or* but it is Administrat*ion*.... My bad.

            Alternatively you can run the below script to update it for > 1 programs at a time:

            UPDATE FND_CONCURRENT_PROGRAMS
            SET MULTI_ORG_CATEGORY='S'
            WHERE CONCURRENT_PROGRAM_NAME =<Prog Short Name>