Report on BIP Catalog Folders details

Karthik_ks

Summary

Report on BIP Catalog Folders details like Roles and Permission etc.

Content

Dear Team,

How to report on BIP Catalog Folders details like Roles and Permission etc.

Need to understand if any report or relevant table names available in Fusion HCM in order to extract list of all roles and permission associated with all the folder/subfolders/reports in BIP catalog.

 

Thanks

Karthik

Wade Wilson

Karthik,

I too would find value in being able to query this. So I’m hoping others respond who may know.

I think I discovered a workaround when I was looking at the services (https://bi-aufsn4x0<pod>.oracleoutsourcing.com/xmlpserver/services) for BI… It seems the ‘getObjectSecurityXML’ call in the security service (https://bi-aufsn4x0<pod>.oracleoutsourcing.com/xmlpserver/services/v2/SecurityService?wsdl) may work. However, it is only returning Role Permissions and not Catalog Group permissions for me. This would not satisfy my need, unfortunately, but may help with yours.

Cheers.

Asif Ranta

Hi Karthik,

Have you find solution?

Regards

Muhammad Asif Ranta

Karthik_ks

Yes Wade. It is not returning catalog permission. Still looking for solution, as i our organization we have huge number of BIP reports and each one having different set of permissions. So would like to find some way to extract this catalog permission to keep it documented atleast. 

 

Regards

Karthik

Karthik_ks

Yet to find solution for my query, Asif

Asif Ranta

There must be some solution of it from Oracle its is biggest concern of audit department in many organization that which people have which reports accesss.

 

Regards

Muhammad Asif Ranta

Karthik_ks

Yes same concern we have. I have checked with oracle, audit functionality on catalog permissions (ER) will be available in future release. I think it is ready and if required wit hstrong business justification, they can try to backport the functionality

 

Regards, Karthik

Sudhesh Nayak

We're on SAS and I am able to access the security service, query the model (getSecurityModel) and I get a response back, confirming all is well with SOAP.

HOWEVER, when calling getObjectSecurityXML, I get  

         <faultcode>soapenv:Server.userException</faultcode>
         <faultstring>oracle.xdo.webservice.exception.OperationFailedException: java.lang.NullPointerException</faultstring>

 

I'm using the same user for adminUsername tag. Can you help?

 

 

Karthik_ks

Below idea has been raised for this. Please share your business case and justification. 

Number: E5AB73293F

 

Alok Suraj-Oracle

Hi Team,

 

Did anyone of you find solution on this.

 

Thanks

Alok