Looks like new prompt is affecting the second section instead of correctly filtering the third section. Try the below: Verify Prompt Scope: Check if the prompt is properly assigned to the third section in the dashboard properties. Ensure that the prompt targets only the relevant dataset linked to the third section. 2.…

Try the below options:Use a Formula in the Pivot Table Instead of relying on formatting, create a calculated measure in the Pivot Table. Example formula: sql SUM(invoice_amount) / SUM(SUM(invoice_amount)) OVER (PARTITION BY Period) * 100 This ensures that each row displays the percentage relative to the total. 2. Apply a…

It looks like the issue persists even after reducing the length to CHAR(4000), likely because the actual data exceeds the allowed limit. Try the below: Use CLOB Instead of VARCHAR2/CHAR Example: sql CAST("Document and Rating Details"."Rating Comments" AS CLOB) CLOB allows storing large text data beyond the 4000-character…

Hi Hanuman, The ORA-00910: specified length too long for its datatype error typically occurs when a column's defined length exceeds the allowed limit for its datatype. In your case, it seems that a VARCHAR2 or CHAR field is being assigned a length that exceeds the maximum allowed. Try the below: 1. Check Column Lengths…

Navigate to the Advanced tab in the analysis editor and ensure the Bypass BI Presentation Services Cache option is unchecked to allow cached data to be displayed. Set DISABLE_CACHE_HIT=1 in the Advanced tab to prevent unnecessary re-execution. Check this: Advanced Techniques: Set Caching Options for Your Analysis Cache —…

Check below as it might be helpful: How to Configure API fnd_request.add_delivery_option to Send Email Output As An Attachment? (Doc ID 2972868.1) How To Send Output File Of a Scheduled Process To An Email Account (Doc ID 1983635.1)

Check below as it might be helpful: FA: SCM: OM: SQL Query: Querying Customer, SHIP_TO and BILL_TO Information on an Order (Doc ID 2235032.1) SQL to find Sales Order Customer, Ship To, Bill To and Invoice for a Sales Order — Cloud Customer Connect

Try the below options: Check the Report Properties in BI Publisher Go to BI Publisher and open the report. Navigate to Properties → Layout Name. If translation is supported, you should see an option to extract an XLIFF file for translation. 2. Use XLIFF for Layout Name Translation If the layout name is not appearing in the…

It looks like the duplicate rows issue is occurring because the custom subject area lacks a proper connection between product and revenue tables. Please check the below: How to delete duplicated records in OTBI Analysis — Cloud Customer Connect Duplicate Values in OTBI Report — Cloud Customer Connect

Try below options: Use a Separate Query for Employee Data Instead of directly joining both subject areas, create a subquery or a separate analysis that pulls employee details from Project Costing - Actual Costs Real Time. Then, use Union or Filters to merge the correct employee data. 2. Modify the Join Conditions Ensure…

Try the below options: Using SQL (TRUNC Function) If you're writing a SQL query, use: sql SELECT TRUNC(learning_due_date), TRUNC(completion_date) FROM learning_table; This removes the time portion, leaving only the MM/DD/YYYY format. 2. Adjusting the Date Format in OTBI In Oracle Transactional Business Intelligence (OTBI),…

There are several tools that people use to edit SQL in Oracle BI, depending on their needs and preferences: BI Publisher SQL Editor Oracle SQL Developer BI Connector SQL Editor Notepad++ or Text Editors Oracle Analytics Query Builder

Oracle Fusion allows you to save historical executed reports and review them later using the Report Job History. BI Publisher Scheduled Reports You can schedule reports in BI Publisher and configure them to save historical executions. The saved reports can be accessed under Report Job History. 2 . Viewing Report History…

Can you please elobrate the requirement. Do you have 2 different report for termination data and previous performance ratings which you want in single dashboard? Provide the details with screenshot explaining current result and expected result.

Please check this: where to add parameter effective date conditions to OTBI — Cloud Customer Connect

Please review the below doc: Creating Analyses and Dashboards in Oracle Transactional Business Intelligence

Please review the below doc:

Please check the below links: Solution Brief: Analytics and Reporting for Oracle Fusion Cloud Applications - Oracle Analytics Overview of Oracle Fusion Financials Reports and Analytics Work Area

@George Mattar :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 and…