This discussion is archived
2 Replies Latest reply: Nov 20, 2012 5:52 PM by 973049 RSS

Secured Synonym

973049 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points