Ho @Anil Pandey-Oracle, Try the below:Use normalize-space() in the RTF Template Wrap your field expression like this: xml Avoid fo:bidi-override Unless Necessary While fo:bidi-override helps with left-to-right formatting, it can introduce Unicode control characters. If your data is already left-to-right (e.g., numeric…

Hi @Mark Stoker, You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali

Try running the below: Run the “Refresh Manager Hierarchy” Process Run “Synchronize Person Records”

Hi @AVorster-Oracle, As I mentioned earlier, You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali

Hi @User_KNFCO , Please try the below: SELECT ID, Test_Date, Test_Type, Test_Result, COUNT(*) OVER ( PARTITION BY ID, Test_Type ORDER BY Test_Date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS Attempts FROM ( SELECT *, MIN(CASE WHEN Test_Result = 'Pass' THEN Test_Date END) OVER (PARTITION BY ID, Test_Type) AS…

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 @Amit Kumar Sah , Try the below:Use @section with Page Numbering Logic Wrap Each Customer in a Section In your RTF template, use: <?for-each@section:Customer?> Use Page Number Fields In the footer or header of your section, insert: Current Page: <?page-number?> Total Pages in Section: <?section-total-pages:Customer?>…

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,…