Reports
Discussion List
-
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 105 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 233 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 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 275 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 69 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 74 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
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 13 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 34 views 0 comments 0 points Started by User_2025-02-05-14-11-28-072 HCM Extract
-
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 588 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
-
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 92 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 23 views 6 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
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 208 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI: "Performance Task": How to get 1 value per employee on report?Summary: All Performance Tasks show as "Ready" unless the task has been started, then it gets a second value of "In Progress". I would like my OTBI report to only have o… -
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…Varkey George-Oracle 152 views 3 comments 1 point Most recent by User_XHDBT Reporting and Analytics for HCM
-
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe…User_2025-02-04-08-51-08-912 587 views 2 comments 0 points Most recent by User_XHDBT Reporting and Analytics for HCM
-
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?Riti Malhotra 36 views 13 comments 0 points Most recent by Caleb Pingelton Reporting and Analytics for HCM
-
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet…Prateek Parasar - GTUK, ACE Pro 111 views 9 comments 0 points Most recent by Shruthi Ramesh Reporting and Analytics for HCM -
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…Padamatinti Varsha 20 views 4 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio…
-
BIP Report Export Issue for Excel FormatSummary BIP Report Export Issue for Excel FormatContent Hi Experts, BI Publisher Report able to generate in PDF, where as if we try to export in to Excel, getting error … -
CR/LF values in rtf template issueSummary CR/LF values in rtf template issueContent Hello All, We developed an interface file and this file will be read by mainframe system. I am seeing a strange issue t…
-
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil_Makhiza 46 views 11 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac…Aloka Bhattacharya 19 views 2 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 97 views 5 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for HCM
-
How dependent parameter works in OTBI Report, BI Report and DashboardSummary How dependent parameter works in OTBI Report, BI Report and DashboardContent Hi Experts, Can someone explain how the following thing works in OTBI Report, Dashbo…
-
Sample snapshots of OOTB Reports and AnalyticsContent Hi Everyone, Client need sample snapshots of all OOTB report and analytics, Let me know where can i get all snapshots of OOTB report and analytics. Please let me…Reddykrishna Chidella-Oracle 38 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM