I am a user logged into Resp: XXXX
MO:Operating Unit of XXXX is ABC
MO:Security Profile of XXXX is XYZ
In the Defn of XYZ I have given 3 OUs = ABC, DEF, GHI
I have a concurrent Prog :Prog1 attached to the Request group of XXXX
Requirement is I should be able to run the conc program- Prog1 at will ....for ABC or DEF or GHI alone and also for all 3 combined.
If I register the conc prog in "Single" mode I would be able to run the Prog for ABC or DEF or GHI alone.
If I register the conc prog in "Multiple" mode I would be able to run the Prog for ABC , DEF and GHI combined.
But is there a way to have both these capabilities in one conc program? ie without changing the conc prog reg everytime?
Yes - I have seen this done.
Register the report as multi or single it doesn't matter avoid using the secured synonyms e.g. use po_headers_all then put a parameter on the org_id so something like
You may have to do a custom valueset to do. But personally I don't like this requirement and would push back on it as much as you can. As basically you are ignoring the application security and creating report specific security.
Thanks for Your Inputs.......
Even I dont want to use the ALL tables and then do a manipulation of the orgid using a p_org_id user parameter.
I was wondering if there is a way to use the multiorg synonym and at the same time dynamically change the multiorg mode while submitting the conc program... Which I guess is not possible....
I know this is a bit of weird way of doing it but could you
Register the programs with a single mode and one with a multi mode but do not assign to a request group
Register a pl/sql wrapper program of the same name with the same parameters but one additional one saying SINGLE or MUTLI then use pl/sql logic to run the standard submit program api choosing which version of the report to based on user input. Its not exactly dynamic but might fulfill the requirement. This program would be the only one the user would see