Reports
Discussion List
-
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 35 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 43 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 149 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 42 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 26 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 125 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 103 views 9 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Text function ColumnNumber in formulaContent Is it possible to use the result of the text function ColumnNumber in a formula? I tried referencing the row with the text function, but receive an error that fo… -
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 28 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 34 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 63 views 5 comments 1 point Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Access Permission in HFRSummary What is the difference between Full Control, Modify, Inherit access which we give from explore the repository. I didn't find anything from docs -
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 51 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 29 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Inside Bar Edge numbers will only render in black fontSummary Inside Bar Edge numbers set as any colour, will be rendered in PDF/embedded in content as blackContent Hello! I have built some management reports which contain …James Wilson-234586 20 views 5 comments 0 points Most recent by James Wilson-234586 Narrative Reporting -
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 37 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 56 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 172 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 … -
Migrate non-Hybrid BSO Cube to EPBCSummary We are encountering performance issues after LCM import into EPBC and hybrid enablement.Content We are transitioning from a non-Enterprise version of PBC to an E… -
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 -
Valid Intersection is not working in the HFRSummary We have setup valid intersection for two dimensions called Cost Centre and Analysis, It is working fine in the forms but not working in the financial report (HFR… -
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 22 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 159 views 1 comment 0 points Most recent by User_2025-02-05-22-13-16-277 Reporting and Analytics for HCM