You can try the below: Using a SQL Filter in OTBI You can create a filter condition that selects the quarter chosen by the user and automatically includes the previous two quarters. Example logic: sql WHERE Fiscal_Quarter IN (Selected_Quarter, Selected_Quarter - 1, Selected_Quarter - 2) Ensure that the quarter values are…

Please try below to resolve this: Verify the Interaction Settings – In OTBI, ensure that the action for Goals Not Created is set to open the correct report within the dashboard rather than prompting a selection. Check the Report Linking – If the report isn't embedded properly, you may need to adjust the linking settings to…

You can try the following: Use Alias Names in OTBI Analysis Before running the SOAP request, modify your OTBI analysis and explicitly set column aliases for each field. OTBI sometimes retains these aliases when exporting via SOAP.

One possible workaround is to check if these fields are available in a different folder within the same subject area or use a join with another subject area that contains supplier details. Review the below Km note as it might be helpful: Fusion Applications OTBI: Guidelines for creating cross subject area analyses in…

One approach to achieve this is by using pivoting or joining techniques: Pivot Table Method: You can pivot the comments column based on the role (Manager vs. Employee) so that both appear in a single row. Union or Case Statements: If you're working with SQL, you might need to use a CASE statement or self-join to align the…

Calculate the Difference Using Built-In Date Functions Example in SQL: sql SELECT TRUNC(MONTHS_BETWEEN(TO_DATE('02-07-2025','MM-DD-YYYY'), TO_DATE('05-01-2024','MM-DD-YYYY')) / 12) AS Years, MOD(TRUNC(MONTHS_BETWEEN(TO_DATE('02-07-2025','MM-DD-YYYY'), TO_DATE('05-01-2024','MM-DD-YYYY'))), 12) AS Months,…

There are memory guard limits that are set on the BI server which helps in performance and limits the chance of a BI server crash. These parameters are set fleet wide and cannot be changed. Solutions to Reduce Report Size & Prevent Errors: Optimize Data Model SQL Queries Reduce Output File Size Choose Alternative Delivery…

Check Mail Server Limits: Even though you've increased the BI Publisher attachment limit to 500 MB, some mail servers impose their own message size restrictions.Ensure the email server supports large attachments. Try Reducing unnecessary columns. Splitting reports into multiple smaller scheduled reports. Exporting to CSV…

To develop and manage OTBI Agents in Oracle Transactional Business Intelligence (OTBI), the following BI roles are typically required: BI Administrator Role BI Author Role

Currently connections to the Microsoft Azure sFTP server is not supported. You may want to visit this Idea Labs posting to request an enhancement for Microsoft Azure:

Hi Kirthi, Please review the below doc which might help you: Fusion Applications BI Publisher : How Should We Create New BI Publisher Reports or Customize Existing Seeded BI Publisher Reports? (Doc ID 1926322.1) 

You can review the Data Lineage doc which has all the details from Column/Table mapping to Presentation Column mapping .