Reports
Discussion List
-
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 751 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM -
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…
-
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…
-
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. 11 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…
-
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… -
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 192 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…
-
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 19 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …Shirlene Chan 56 views 7 comments 0 points Most recent by Ravi Shinde Reporting and Analytics for ERP
-
Customize Payroll Activity Report and/or Periodic Payroll Activity ReportQuestion: What are best practices for customizing the seeded, legacy Payroll Activity Report and/or newest Periodic Payroll Activity Report? How can we add in assignment… -
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.…Jianzhong Tian 1.5K views 4 comments 7 points Most recent by Tia Bly Reporting and Analytics for HCM -
Financial Reporting Studio Issue: 2026 Data Not Appearing (current Year)Dear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2026 data in our reports. Pervious year data showi…
-
Can Reports in the Navigation Flow be configured to open in a new browser tab?Can cards in the Navigation Flow be configured to open a report in a new browser tab (similar to how drill to content links within reports will open new browser tabs)? I… -
Is it possible to preserve report prompts?Summary: Here is a screenshot from a PowerBI dashboard. I selected two members (highlighted in the green box). The report shows me details for the selected members and t…
-
We tried to use Reflect Changes from Edited Reports Sooner solution in fusion but it is not workingSummary: Hi team we have made the changes in the PR PO Approval Pages as per our requirement. We need to test the output. As a standard functionality system will take 24…