Reports
Discussion List
-
Extract got failed after adding Exract RuleSummary Extract got failed after adding Exract RuleVersion 20B (11.13.20.04.0) -
Security QuestionSummary Report needs to be run by many usersContent Hi, I have a simple report that runs using a From and To Date prompt that shows all New Hires within the chosen date …User_2025-02-05-22-44-35-842 43 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Payroll - Element Entries History Real Time - Input ValueSummary Payroll - Element Entries History Real Time - Input ValueContent Hi, I am trying to create an analysis for the subject area Payroll - Element Entries History Rea…User_3YB1F 80 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Single day Entry for each absence durationSummary Single day Entry for each absence durationContent Hi All, We have requirement where we need to fetch all the absences of employees as a single day entry. for exa… -
Analysis is giving an ODBC Driver errorSummary Analysis joining two subject areas not workingContent I have an analysis that has been working up until this morning (the analysis is emailed to our team every w…User_2025-02-04-08-51-08-912 41 views 15 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Fusion Table for BIP informationContent Hello All, Is there any tables available which is holding the information of BIP(Data models, template, etc) details. Thanks GaneshGanesh Kokkula 49 views 2 comments 0 points Most recent by Ganesh Kokkula Reporting and Analytics for HCM -
Table name for employee education detailsSummary Where can we find employee degree and major informationContent We are trying to create a BIP report to shows employee education details and we are unable to find… -
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 151 views 5 comments 2 points Most recent by User_R6A85 Reporting and Analytics for HCM -
Adding 2 date parameters to a reportSummary Report needs to report either by Termination Date Range OR Last Update Date RangeContent I have built a report that has 2 date Ranges on it Change Date From and …User_2025-02-04-08-51-08-912 47 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Compensation Salary History Details Subject Area not returning termsSummary Compensation Salary History Details Subject Area not returning termsContent Compensation Salary History Details Subject Area not returning terms. It will only re…TerryM01 30 views 23 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there delivered Affirmative Action Report for US in Oracle HCM CloudContent Hi All I was told there should be delivered report for Affirmative Action Report for US as its statutory requirement But I could not find one. Can you please let…Naveen Jayaraman-48236 129 views 1 comment 1 point Most recent by Tony Johnson-Oracle Reporting and Analytics for HCM -
Is it possible to view reports as employee?Content Hello experts, our customer would like to enable a user to see a specific OTBI report. However, at the same time this user cannot have access to My Team and My C…Valerio Curzi 107 views 9 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Benefit Pending Action Item informationSummary Need back-end table name for Benefit Pending Action Item informationContent Hello Everyone, Can anyone share the table name/column name to identify benefit "Pend… -
Free text parameterContent Hi, I have a requirement to include a free text parameter for termination Letter where HR will enter Termination reason in the Parameter while generating the Let…User_2025-02-06-14-37-05-233 30 views 3 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Joining Workforce Events to Person Real TimeSummary Having trouble getting the data to align between the two subject areasContent Hello Everyone, I've created a simple example of an analysis we're making to see ho…Rob F 40 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
RTF Template - Field validation with the combination of xdofx and xdoxslt functionsSummary RTF Template - Field validation with the combination of xdofx and xdoxslt functionsContent Hi , I need to add a validation on other-compensation.value field , wh…Phani S-Oracle 64 views 5 comments 1 point Most recent by Phani S-Oracle Reporting and Analytics for HCM -
OrganogramSummary Organogram RequiredContent Hi, I have come across many previous posts regarding organogram / organisational charts and none deliver a proper organogram whereby e…User_2025-02-05-22-44-35-842 53 views 37 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Change column to NumericSummary I want to change a column to numeric so I can add formulas. How would I do so in the SQL?Code Snippet SELECT "Workforce Management - Worker Assignment Real Time"…User_2025-02-06-07-21-22-662 35 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Analysis for finding positions with more than one EmployeeSummary Need a report that shows a list of positions that currently have more than one Employee in the positionContent I am trying to build an audit report that shows th…User_2025-02-04-08-51-08-912 41 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
20c Subject Area Changes - Transaction AdministrationSummary Additional fields added to Human Capital Management - Transaction Administration Real TimeContent I have been reviewing the readiness docs for 20c HCM, but I hav…ndryden 61 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Report with Position Headcount data as of current month and as of previous month in the same anSummary Current and Previous month data in the same OTBI analysis based on AsOfDate variable parameterContent Hello All, Request help! Trying an OTBI report which includ…pooja yelsangikar-Oracle 170 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Rows For Assignment ManagerSummary Updated the assignment manager job today and each employee now has multiple rowsContent Hi, Today we ran the jobs to update the assignment manager fields. After … -
How to increase the number of characters for a OTBI Analysis columnContent Hello experts, a text column returns truncated text while in Core HR I can see the entire text. As a result, I think that it depends on the report configuration.…Valerio Curzi 46 views 5 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Canadian Payslip modificationSummary Need to determine the path in the catalog for the payslip as well as how to make a modificationContent With the COVID-19 issue, we have had to add new pay elemen…User_2025-02-04-08-51-08-912 26 views 5 comments 2 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Resume an automated Job - after PAUSINGSummary Resume an automated Job - after PAUSINGContent Resume an automated Job - after PAUSING results in: 1. immediate submission of the job 2. And also runs for all th…User_2025-02-05-22-13-16-277 156 views 1 comment 0 points Most recent by User_2025-02-05-22-13-16-277 Reporting and Analytics for HCM -
OTBI - Line Manager cannot report on future dated joinersSummary Line Manager cannot report on future dated joinersContent We have a requirement for Line Managers to see future dated joiners and internal movers. We are using t…User_2025-02-05-05-26-04-705 57 views 12 comments 0 points Most recent by User_2025-02-05-05-26-04-705 Reporting and Analytics for HCM -
Pivot Salary Data For Employee PopulationSummary Want to display salary data for employee population without summing the dataContent Hi - I am trying to create a pivot table in OTBI that would show salary data …Kyle Norris 35 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to lookup the position name of an employee from another analysisContent I am creating an analysis for Development goals and since it's tied to the home/primary assignment I am trying to populate the position name and department name …Mario B 20 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFSeSummary OTBI Analysis is running out with above error after 20B upgradeContent Hi All, One of the Analysis which is having below subject areas is running out in error (c… -
Calendar event - Holiday ListSummary Calendar event - Holiday ListContent Team, Is there a way to fetch holiday list from Manage calendar event on country wise basis using OTBI report ? (Without usi…acmhari 97 views 2 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM