Ok. Can you please help me to write the correct script that I can run from 'Prefix'? I am trying the one below and it is not working - EVALUATE('APPS.MO_GLOBAL.SET_POLICY_CONTEXT(%1,%2)','S',1103)

Thanks again for the reply. But if I use RPD Connection Script then I think this query will be executed for all the reports which uses this connection pool. This requirement is for only one report. Can I use the "Prefix" option in "Advanced" tab?

Hi Christian Thank you for your reply. This procedure does not return any value. But we need to execute this first thing whenever a new database session is opened in order to see data from some Oracle Apps tables. As my OBIEE report queries those tables, I need to execute this procedure from OBIEE as well before the…

Hi Gianni Thank you for the suggestion. Yes, we also thought of the same approach to test user built reports. It is going to be an one shot migration but we are still in POC stage. We are working on few requirements, one of them being the regression testing for user built reports by the IT support team post migration.

Hi Gianni Thank you for your response. But I think we can't use separate config files per user as we will the need to provide user password in the file, which we are not aware of. We generally use "Impersonation" or "Act as" feature to login to Analytics as different user.