Hi @AVorster-Oracle, Please check this: Delivered Reports in Fusion HCM — Cloud Customer Connect What all are the standard reports available in Oracle Fusion HCM? — Oracle Analytics You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks,…

Hi @Amit Kumar Sah , You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Check this: Preview Invoice Report Thanks, Riyaz Ali

Hi @Anjum Saeed , If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Thanks, Riyaz Ali

Please check below: Create a Chart from an OTBI Analysis Graph Data in Analyses

If you are not getting the "Bar width" , "Bar gap" or "Cluster width".Try the below:Change the Graph Type Switch between Vertical Bar, Horizontal Bar, or Clustered Bar. Clustered Bar graphs naturally introduce spacing between categories. Limit the Number of Categories Fewer categories on the X-axis = more space between…

Hi @User_63K6C, Try the below:To ensure the correct order of operations, you need to calculate Total Feet Shipped at the item level first, then aggregate that result by Month. Create a Calculated Field at the Granular Level Name: Item-Level Feet Shipped Formula: {Quantity Shipped} * {Item Length} This ensures the…

Hi @User_HCKQU, Try the below:Rename Columns Without Special Characters Change "Actuals/Targets" to a simpler alias like "ActualsToTargets": sql select A.*, case when ActualsToTargets >= 1 then '>=100%' when ActualsToTargets >= 0.75 then '>=75-100%' when ActualsToTargets >= 0.5 then '>=50-75%' when ActualsToTargets >= 0.25…

Hi @KDR, Try the below:Instead of using the “Generate RTF layout” button, follow this approach: Create Report from Data Model Go to your Data Model. Click Create Report. Use the Report Wizard to generate a basic layout. Save the report and download the sample XML data. Design RTF Template Manually Open Microsoft Word with…

Hi @Anjum Saeed , Try the below:Use CSV Format Instead: Export the report as Data → CSV. CSV files don’t have the same row limit and can handle hundreds of thousands of rows. You lose formatting, but you retain all data. Split the Report Output: Modify your report logic to split data into multiple sheets or files. For…

Hi @Amit Kumar Sah , Please check the below: Preview Invoice Report Fusion Applications BI Publisher : How Should We Create New BI Publisher Reports or Customize Existing Seeded BI Publisher Reports? (Doc ID 1926322.1) Thanks, Riyaz Ali

Hi @Josue Jimenez, Try the below:Instead of embedding the image directly, you can reference the image URL dynamically in the RTF template using BI Publisher’s url:{} syntax. Steps to Implement Construct the Image URL in Your Query You already have this part mostly done. Ensure the final URL looks like:…

Hi @User_P6HYL, Try the below:Create Condition-Based Columns First Go to your OTBI analysis. Add a column from the subject area. Click the gear icon next to the column → Edit Formula. Write your condition-based logic using SQL expressions like: Save the column with a meaningful name. sql CASE WHEN "Employee"."Department" =…

Hi @Narendar Rao Naineni, Please try the below: Open the OTBI Report: Navigate to the OTBI report that contains the bar graph you want to modify. 2.Edit the Graph View: Click on the graph view (not the table or pivot view). Choose Edit View to open the graph configuration. 2. Access Graph Properties: In the graph editor,…

Hi @Narendar Rao Naineni, Please try the below:Open the OTBI Report: Navigate to the OTBI report that contains the bar graph you want to modify. 2.Edit the Graph View: Click on the graph view (not the table or pivot view). Choose Edit View to open the graph configuration. 2. Access Graph Properties: In the graph editor,…

Hi @AVorster-Oracle, Please check this : Platform Reports Library Opens Reports and Books Directly in Excel Exporting Formatted Reports to Excel Thanks, Riyaz Ali

Hi , Please check the below as it might be helpful: Line Manager not able to view the direct reportees — Cloud Customer Connect Fusion Global HR: Line Manager is not able to access direct reports in My Team (Doc ID 2303898.1) Thanks, Riyaz Ali

Hi @Varun Dhondea , Check this: BICC PVO for privileges and their link to roles — Cloud Customer Connect Thanks, Riyaz Ali

Hi @User_B857U , Try the below:Create the Dashboard Prompt: Go to New → Dashboard Prompt. Select a subject area that contains the column you want to prompt (e.g., Business Unit, Department). Add the column as a Column Prompt. Set it to populate a presentation variable, e.g., P_BU. Modify Each Query in the Union Analysis…

Hi @skhan, The problem arises because the TopN filter is applied before the prompt value is processed, causing the report to default to a specific Business Unit and ignore user selections. Try the below:Use a Presentation Variable in the Filter: Instead of hardcoding the TopN filter, use a presentation variable tied to the…

Hi @Ivony Ann Paula Salango , Extra Spaces or Characters. These often come from: Concatenated columns with manual spacing. Hidden HTML tags or formatting in text columns. Null values being replaced with placeholders. Try the below:Use TRIM() and REPLACE() functions in your OTBI column formula: sql…