This content has been marked as final. Show 4 replies
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