Analytics Software

Hi All,

We are developing the reports in Oracle BI Discoverer 10G on Release12. In Release12
Multi Org Views are now replaced by RLS Secured Synonyms.

Generally in 11i ,A table is created in AP Schema, named AP_INVOICES_ALL, A synonym named AP_INVOICES_ALL is created in APPS schema referring to AP.AP_INVOICES_ALL and Create a Org Specific view AP_INVOICES in APPS schem

In R12, A table is created in AP Schema as AP_INVOICES_ALL, a synonym named AP_INVOICES_ALL is created in APPS schema, referring to AP.AP_INVOICES_ALL and Another synonym named AP_INVOICES is created in APPS, referring to AP_INVOICES_ALL, A Row Level security is applied to AP_INVOICES, using package function MO_GLOBAL.ORG_SECURITY.

Every body will know this.

But, my client wants implement the security for reports at org level. Here in R12 all the Multi-Org views are replced with RLS synonyms and we can access the multiple organizations data in single responsibility.

I tried like i have created one custom folder with synonym(select * from apps.ap_invoices) and i have login with xxx responsibility which attached "MO: security profile" with two organizations.

If i develop the work sheet with this folder , i can able to see only one org data that is assigned by the "MO: Operating Unit".

Please suggest me how to implement the multi-Org Access Control in release12 for discoverer reports.

Please reply , its very urjent to know.

If u doesnt understand my question , i will explain clearly.

Regards,
Ramakrishna