Reports
Discussion List
-
Pictorial Representation of Organization TreeSummary: Pictorial Representation of Organization Hierarchy Content (required): HI Team, How we can create Pictorial Representation of Organization tree. Need to display…Reddykrishna Chidella-Oracle 72 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le… -
Unable to edit delivered RTF report templateSummary: Unable to edit delivered RTF report template Content (required): Hi, I'm attempting to edit the benefits summary delivered RTF template. The issue I'm running i…User_2025-02-11-21-40-21-159 51 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 103 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…Mike Borghoff 51 views 3 comments 1 point Most recent by Mike Borghoff Reporting and Analytics for HCM -
Seniority Date values are not available in OTBISummary Seniority Date values are not available in OTBIContent Hi Team, Seniority Date values are not available in OTBI, Workforce Management Assignment Real Time and Ev…User_2025-02-06-10-22-06-460 272 views 6 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include… -
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…saravana maneeian subhramaniun 65 views 1 comment 2 points Most recent by User_7836 Reporting and Analytics for ERP -
Reporting on Transaction Incidents per User?Summary: We would need to be able to report on transactions done by certain users (aggregation of all incidents/controls where the selected user has done possibly fraudu…Ann Van Roosbroeck 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 282 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Report on Employees on Leave during a certain time periodContent Hello - We are trying to find a way to report on employees who were/are on a leave of absence during any given time frame. The issue we are having is that there …Shanna Oppenheim 83 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 71 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Best ways to provide data extracts for external applications/data warehouses/dashboardsHi everyone, We have been receiving more and more requests for data extracts from our Planning application into various data warehouses, dashboards (such as PowerBI), et… -
Position Details with Grade Minimum and MaximumSummary: I am trying to get a report of all active positions, their grades and pull in grade min and max. I don't want to base this off of worker assignment since I want…Jennifer Wiggs 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to connect two data groups using number DBI and text DBI in HCM Extracts?Summary: In sql we can use to_char(HDOR.documents_of_record_id) = to_char(FAD.pk1_value) but in HCM Extracts is there any way to connect. Please help me on this. Content…User_2025-02-05-14-11-28-072 31 views 0 comments 0 points Started by User_2025-02-05-14-11-28-072 HCM Extract -
I want vertical text in Text ColumnSummary: I want vertical text in Text Column Content (required): Trying to rotate the text to vertical format Version (include the version you are using, if applicable):…
-
Sorting throws off the Conditional PropertiesContent I am using the ascending sort option on row dimension members, and conditional properties are set to prefix a $ in the first row for data column. This is however… -
Position/Incumbent Report - by FTEContent I am trying to create an analysis that lists the current active positions, by department, the position FTE and all employees assigned to the position and their F…Annette M 613 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Narrative Reporting - How do we run the REST API /rest/v1/jobs to execute a bursting definition ?Content We are trying to use REST API /rest/v1/jobs to execute a bursting definition using Postman. * Narrative Reporting API = /rest/v1/jobs * API Type = POST * jobType… -
How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Summary How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Content Hi Experts, How to Display BIP Report Output file with Data stamp. Examp…Bala Kasineedi 93 views 6 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM -
Not able to generate csv file which has both English and ArabicContent Hi, I am not able to generate pipeline delimited csv file which contain both English and arabic values. Arabic text is replacing with some other characters in CS…Nivya Mathire 20 views 6 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Task Manager - Integration to Reports DcoumentsSummary Documents uploaded in Reports DirectoryContent Good Day, is it possible to create an integration on the Task Manager to select a documents that was uploaded on t…Resh 18 views 3 comments 1 point Most recent by Kurt-ARCS Support-Oracle Financial Consolidation and Close -
Management Reports - Availability in Smart ViewSummary: Management Reports - Availability in Smart View Content (required): We are currently building out Management Reports in our Planning application. While we can e… -
Payroll element entries costingSummary OTBI Subject Area and fields for data.Content Under the payroll element entries - Cost Account are the fields Fund___ Purpose__ Prc__ Object___ Location___ CostC…User_2025-02-08-08-49-19-186 33 views 3 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 212 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM