Reports
Discussion List
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …Aishwarya_Saju 11 views 0 comments 0 points Most recent by Aishwarya_Saju Reporting and Analytics for HCM -
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 51 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM -
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e…Claudia Linares L 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…Aishwarya_Saju 1 view 0 comments 0 points Most recent by Aishwarya_Saju Reporting and Analytics for HCM -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP -
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):… -
which tables store information about data access set for user?I need to a query to read for each user which BU have access to -
No data shown for Time and labor under audit reportsSummary: We are trying to setup audit trail for Time and Labor and have enabled it but when we go to audit reports and select all the necessary parameters, still there i…Mehul Chandra 1 view 0 comments 0 points Most recent by Mehul Chandra Reporting and Analytics for ERP -
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a… -
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 730 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP -
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…Aishwarya_Saju 11 views 2 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How can we have the $ show on the report when the value is zero (zero replaced with Dash)Summary: When cell formatting is being used if positive Prefix "$" and negative prefix "$(" , the report is not showing a $ when the value in the cell is zero (zero repl…Angela Hamann 21 views 2 comments 0 points Most recent by Angela Hamann Financial Consolidation and Close -
Calculate Interest Expense in LDRHello, \ I am trying to calculate interest expense but it does not match the LDR. The reason is number of days used in the calculation. The calculation is done like numb… -
Sample Report Outputs of Seeded Oracle HCM ReportsSummary: Sample Report Outputs of Seeded Oracle HCM Reports Content (required): Where do we get the list of all seeded Oracle HCM Reports and their sample output files? …Mani Venkataraman 71 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…Ashish Chawla-277800 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Required Tables and column to store the Currency setting details under Manage Financial Plan typesSummary: Hi Team, What are the Tables and columns that store the Currency setting details under Manage Financial Plan types - functionality "Use same conversion attribut… -
how BIP job that retrieves data from an Oracle Database table containing a BLOB columnWe have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integratio… -
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 11 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
I am unable to join between Project types and class category for the task project typesSummary: Hi Team, Could you please help us to get class category under the classification associated with project types in oracle PPM Module Task Name: Manage Project Ty… -
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 288 views 4 comments 2 points Most recent by Atta Oduro Reporting and Analytics for HCM -
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Excessive delays generating XLS output files from Report books starting mid-March 2025Summary: Excessive delays generating XLS output files from Report books Content (please ensure you mask any confidential information): Starting on March 24, 2025, our re…Sean L. Lydon 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
What’s New in EPM Cloud Narrative Reporting and Reports Release 25.08What’s New in EPM Cloud Narrative Reporting and Reports Release 25.08 Please refer to the August 2025 What's New Guide to understand the new features included in EPM Clo…Dave Roberts_-Oracle 81 views 0 comments 1 point Most recent by Dave Roberts_-Oracle Narrative Reporting -
fdi first valueIn FDI what is the formula to get the first value (or last) for a field that may have multiple values. Instead of displaying multiple rows that show each of the values I… -
I need a sql query to fetch number of performance document types usedSummary: I need a sql query to fetch number of performance document types used in the organization in talent management Content (please ensure you mask any confidential … -
RTF Pivot Table Repeating GroupSummary: I'm developing a report where I would need duplicate pivot table based on country and put the data into different spreadsheets in excel. My problem is that Im n…Martin Smid-Oracle 11 views 0 comments 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM