Reports
Discussion List
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 75 views 10 comments 0 points Most recent by RajuKumarOracle-Oracle Reporting and Analytics for HCM -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages… -
Report Location syntax not producing in book outputsWhen using ReportLocation() in Header Body or Footer it will render in a report using HTML preview, PDF or Excel as expected. Outputs When added to a book, PDF or Excel … -
ASO Cube OptimizationSummary: We are experiencing performance impact in ASO Cube for Custom Workforce application. Content (please ensure you mask any confidential information): We have a Pl… -
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo… -
How to exclude few ICP entities while running Inter company matching ReportSummary: How to exclude few ICP entities while running Inter company matching Report Content (please ensure you mask any confidential information): Hi team, While runnin… -
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 445 views 6 comments 0 points Most recent by User_HSKEJ Reporting and Analytics for HCM -
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 21 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Application Role Reports-Manage is only showing Copy URL in Action menuSummary: Power users need the ability to edit reports so were assigned Reports-Manage. According to the Oracle documentation this should give them the ability to Add, ed…LSN_CE 12 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
What’s New in EPM Cloud Narrative Reporting and Reports Release 26.04What’s New in EPM Cloud Narrative Reporting and Reports Release 26.04 Please refer to the April 2026 What's New Guide to understand the new features included in Cloud EP…Dave Roberts_-Oracle 14 views 0 comments 0 points Started by Dave Roberts_-Oracle Narrative Reporting -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…Yaniv 759 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM -
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p…Oriana L. 13 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific… -
BIP report layout hyperlink works with hard-coded parameter, but not with dynamic field valueSummary: I am trying to create a drill-through from one BIP report to another. The source report is a report created with the Layout Editor, and the layout file ends in …Sherie Ross 23 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Rest API or CLI command scripts to export and import of HCM extracts from one instance to another.Summary: Any Rest API or CLI command scripts to export and import of HCM extracts from one instance to another. Any documentation for the same or for other technical obj… -
avoid divide by zero errorSummary: I'm trying to avoid a divide by zero error, but even when I use a formula to do so it still seems to manifest - any ideas? Content (please ensure you mask any c… -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 248 views 4 comments 0 points Most recent by User_A4SYN Reporting and Analytics for HCM -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 193 views 10 comments 0 points Most recent by Rosita Santosuosso Reporting and Analytics for ERP -
Set different alias tables for different columns/rows.Suppose in my report i have selected alias table A, which is what I want for my Accounts which are present in rows. Now for the Entities present in columns, i want to us… -
Concatenate Cell Text or Value within ReportsHello, I'm trying to build a report within the Reports section of Planning that will concatenate a Member Name with the Cell Text or Value from the output of the report.… -
Can I use Copilot in narrative reportingSummary: I want to integrate Microsoft CoPilot into Narrative Reporting reports with Gen AI to utilized summary of the comments with Gen AI and Comments submitted by the… -
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera… -
User is unable to enter the comments in Narrative ReportingSummary: The users have below access, but still they are unable to enter the comments in Narrative Reporting (Can view the comments entered by Admins, though) Power User… -
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a… -
Query to get Languages in ORCSummary: Based on the screenshot I provided, What table in HCM can I get the list of values for the Languages in ORC. Content (please ensure you mask any confidential in… -
Is there a way to change the default export format to xlsx in ERP?Summary: We use Excel 2024. When exporting reports out of ERP, they default to Excel 2007. Is there a way to change the export format to xlsx? Content (please ensure you… -
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which …Sara Suleiman 24 views 3 comments 0 points Most recent by Sara Suleiman Reporting and Analytics for HCM -
EPBCS Reports vs EPCRS Narrative Reporting reports: what tool to choose?Summary: I need to build simple tabular reports with the possibility of creating books from these reports. No complex formatting or commentaries are required. The report… -
Dynamic Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question…