MOAC in BIP Reports

Summary

Implementing MOAC in BIP Reports

Content

Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been able to implement the same.

Fusion Applications BI Publisher : Implementing FINS Security in SQL-based BI Publisher reports using Multi-Organization Access Control (MOAC) (Doc ID 1984271.1)

We have used the synonym ap_invoices instead of ap_invoices_all, however, the data is not restricted. Still all rows are returned.

Are there any pre-requisites to this? or the way in which a user is setup?

 

-- Abhishek