I don't think it is possible to fix the view with 'Table View' all time.

Does this help? https://community.oracle.com/customerconnect/discussion/comment/646714#Comment_646714

You may review: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/create-filters-columns.html#GUID-5B35E956-C6D6-4FFD-A61A-D6B109424044

Fusion Apps, OTBI, Error Message: Exceeded Configured Maximum Number Of Allowed Output Prompts, Sections, Rows, Or Columns (Doc ID 2004256.1) Fusion OTBI: Error: Exceeded configured maximum number of allowed output prompts, sections, rows, or columns - Error Codes: IRVLJWTA (Doc ID 2113475.1)

You may review this: ODI Mapping from OTBI to ADW Database Executes Successfully Without Loading Data (Doc ID 2644462.1)

Keep BI Consumer role and remove BI administrator/ BI Publisher Data Model Developer roles from the user.

This may help you: select JOB_ID,REPORT_URL,OWNER,USER_JOB_NAME,BURSTING,START_DATE,END_DATE from FUSION_BIPLATFORM.XMLP_SCHED_JOB WHERE TO_CHAR(END_DATE,'YYYY-MM-DD') > '2019-05-24' AND TO_CHAR(END_DATE,'YYYY-MM-DD') < '2021-12-01' order by end_date desc;

Fusion BI - How to Connect Power BI Desktop to Fusion DB (Doc ID 2204117.1)

Hi, IN RTF template add below and see if it works. (Replace the Person_ID with the actual column name) <?count(PERSON_ID)?> Regards, Raghavan

Hi Pavel, Is it a duplicate of https://cloudcustomerconnect.oracle.com/posts/4e839f270c Regards, Raghavan

Hi Jonathan, Data models can't be embedded directly into an infolet. As Prudence said, create a report and add it to the dashboard which will be available in the report catalogue. Youtube reference(Steps are almost same in newer fusion versions): https://youtu.be/fhmhMRHYP3Q Regards, Raghavan

Yes, this is not possible.

Hi Neha, Your requirement can be achieved using BI audit reports. Refer below document: 2059102.1 - Fusion Applications BI Publisher: How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Refer section 'Report Runtime Statistics (Execution Count, Time - Min, Max, Median)' in the attached pdf file…

Hi David, For example, your POD URL is: https://xxxx-dev1.fa.us2.oraclecloud.com/ Then BI xmlpserver URL will be: https://xxxx-dev1.fa.us2.oraclecloud.com/xmlpserver/ Hope this helps. Best Regards, Raghavan

No, it's not about the parameter. Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime. If you are using any such in your custom reports you need to modify them with explicit SQL.

Hi Joe, What is the current behavior of the search? is it not case sensitive? Regards, Raghavan

Hi Kobe, You may try the pivot table. https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-4E6D9DBB-0029-4F1C-ACC0-6FD48F7C68A3.htm#BIPRD2283 Regards, Raghavan P

You may check this doc: Fusion BI Publisher - Time Zones Display - Best Practices of Coding (Doc ID 2256176.1)

Execute the query by creating a new data model with the same SQL and see if the data is accessible by that user.

Swapnil, plz create an SR as mentioned in the below Metalink doc. Fusion Applications - BI Publisher - Scheduled Reports - How to Export The Report Job History Output To Excel - Data Model FUSION_BIPLATFORM . XMLP_SCHED_JOB - ORA-01031: insufficient privileges (Doc ID 2210437.1)