Please mark this thread as "Accepted answer", So that it will be useful for others.

Steps to Restrict Tile Visibility by Security Role: Use the Page Integration Wizard When creating the tile, use the Page Integration Wizard to generate a security code. This security code can be linked to specific roles. 2. Assign the Tile to a Specific Role Navigate to Structure > Tools > Configuration. Locate the tile…

Steps to Restrict Tile Visibility by Security Role: Use the Page Integration Wizard When creating the tile, use the Page Integration Wizard to generate a security code. This security code can be linked to specific roles. 2. Assign the Tile to a Specific Role Navigate to Structure > Tools > Configuration. Locate the tile…

Try the below: Enable Fixed Headers with Scrolling Content Go to View Properties in your analysis. Select Fixed headers with scrolling content and click OK. 2. Use a Custom CSS Approach If you're embedding OTBI reports in a dashboard, you can apply custom CSS to enforce column widths.

Check the below doc: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/resize-rows-and-columns-views.html#GUID-2462B793-E4BD-4D10-BB54-4D36FDF43991

Try the below: Session Dependency Issue Some OTBI agents may be tied to an active session. Check if the agent is configured to run asynchronously rather than requiring an active user session. Authentication & Security Settings If recent security updates were applied, they might be preventing agents from running in the…

Try Modifying the Pivot Table Options: Right-click on the pivot table and select PivotTable Options. Under the Layout & Format tab, check For empty cells, show: and leave it blank. This prevents empty rows from displaying.

Try the below options: Use MIN() and MAX() Functions Use ROW_NUMBER() for First and Last Entries You can use ROW_NUMBER() to rank entries and fetch the first and last rows: sql WITH AbsenceData AS ( SELECT absence_start_date, absence_end_date, ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY absence_start_date ASC) AS…

Try the below options: Use MIN() and MAX() Functions Use ROW_NUMBER() for First and Last Entries You can use ROW_NUMBER() to rank entries and fetch the first and last rows: sql WITH AbsenceData AS ( SELECT absence_start_date, absence_end_date, ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY absence_start_date ASC) AS…

Try the below: Modify the Bursting Query You can pass report parameters explicitly in the bursting query by defining them in the data model and referencing them in the SQL query. It allows you to pass parameters to the bursting query using :parameter_name syntax. 2. Embed Parameters in the Dataset Since bursting removes…

If non-administrator users are having trouble accessing OTBI reports, it could be due to role-based permissions or folder access settings. Here are a few things to check: BI Consumer Role – Ensure that users have the BI Consumer Role, which grants them Read/Traverse access to OTBI reports. BI Author Role – If users need to…

To check the history of report executions: BI Publisher Audit – Fusion Cloud retains BI Publisher audit data for 90 days, which includes details of manual report executions. OTBI Audit – Execution data is available for six months, and older data is purged weekly. Please review the below KM notes: How To Configure And Use…

You can create a custom app tile for an OTBI dashboard to make it more accessible for recruiters. Please review the below doc: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/create-your-first-dashboard.html…

Please review the below KM notes and follow to create report from cross Subject Areas: Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1) Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI - KB89403

Oracle Analytics Publisher in Oracle Fusion Apps Cloud is designed to access data from Fusion Apps transactional database. JDBC/JNDI connections to external databases aren't supported. Refer https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/data-source-connections.html

You can use TO_CHAR option as well: sql TO_CHAR("Table"."Number Column")

Please try the below: Edit the analysis Click on Advanced Tab In the Prefix input box, add the following and click Apply and Save the analysis: SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;

Please try the below and see if this helps: Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)

OTBI does allow selective null value inclusion rather than applying a global setting across all columns. You can enable null values for just one column using View Properties in the Results tab. Go to the Results Tab Modify View Properties (Click on the table or pivot view where you want to display null values. Select View…

Ensure TEMPLATE_FORMAT is Set Correctly TEMPLATE_FORMAT = 'HTML' instead of 'eText' that prevents attachments from being included. 2. Modify the Delivery Channel Instead of 'EMAIL', try using 'NONE' or another delivery method that doesn’t generate attachments.