Is there a way to allow SCM user to have access of creating data model using SCM tables but restricts access of HCM tables?
Hi @User_OJ47U
It is currently not possible to restrict access to the tables.
There is currently an idea
https://cloudcustomerconnect.oracle.com/posts/9c82838cd2
Users having BI admin or BI author roles can query all the tables in Fusion schema from data model. It is not possible to restrict specific tables from BI publisher data model. If you do not want them to query those tables from data model then please unassign BI admin or BI author roles from those users. If they are developers you can assign those roles in Dev environments where real time data not available.
Hope it helps!
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that have excel templates to run, their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
Hello Team, I am generating a BI Publisher report scheduled through an ESS Job with the output format as CSV. When the report returns no data, I need the output file to contain only the column headers. However, the generated CSV contains the headers followed by an additional first data line with delimiters only, which is…
