Reports
Discussion List
-
BI Report Output file renamingSummary Can we rename the report output file name in BI Reports, currently it’s coming as report job id.Content Can we rename the report output file name in BI Reports, …Vibha Pandey - Oracle 41 views 3 comments 0 points Most recent by Subhash Kumar Bichhode-Oracle Reporting and Analytics for HCM -
Need a table name/Coumn name to identify whether it is a 2020 tax card or 2019 tax cardSummary Need a table name/Coumn name to identify whether it is a 2020 tax card or 2019 tax cardContent Need a table name/Coumn name to identify whether it is a 2020 tax …User_2025-02-04-07-00-18-658 54 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM -
Line Manager information of Future hired WorkerContent Hi, I have created OTBI report listing all our future hired Workers (xml attached). For some reason the Line Manager information is not populated on the report. …Niko Hölttä 52 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 337 views 7 comments 11 points Most recent by Claudio Civati Reporting and Analytics for HCM -
Get Data From Previous Row in AnaltycsSummary Get Data From Previous Row in AnaltycsContent Hi, I have null values in Analytics. I dont want to show like null values. So I want to get data from previous row …User_2025-02-05-02-38-04-251 74 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Goals Version TypeSummary When an employee updates their goal, update does not reflect in report until Version Type = ACTIVEContent Is it normal behavior for when an employee updates a pr…User_2025-01-28-20-36-10-715 63 views 4 comments 0 points Most recent by User_2025-02-04-23-22-13-274 Reporting and Analytics for HCM
-
Duplicate Element EntriesSummary Element entries for employees are appearing twiceContent Hi, Please see attached XML file/ If an employee has more than one element entry then that will appear o…User_2025-02-05-22-44-35-842 51 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL for Hire Date + 30 daysSummary does anyone have a quick SQL for finding employees hitting their 30 day mark after hire?Content Hi folks - hoping this is an easy one! Does anyone have a quick a…Matthew Grillo-95429 49 views 2 comments 0 points Most recent by Matthew Grillo-95429 Reporting and Analytics for HCM
-
Adding Dynamic BI Publisher Link to DashboardSummary Creation of a simple dashboard with links to all reports in our instance (static BIP links don't solve our issues)Content Hi all, We are trying to create a more …User_2025-02-05-05-51-12-049 148 views 17 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Will it be possible to get direct & Indirect employee assign to managerSummary Will it be possible to get direct & Indirect employee assign to managerContent Hi All, Will it be possible to get direct & Indirect employee assign to the manage…User_2025-02-05-01-04-36-989 54 views 11 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
BI Report for IntegrationSummary Need a BIP report with .dat output formatContent Hi Experts, As a part of business requirement we need a BI report with output in .dat format and need to send th…Charan Kollipara 54 views 4 comments 0 points Most recent by User_2025-02-06-08-02-11-890 Reporting and Analytics for HCM
-
Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBISummary Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBIContent I have a report using a Data Model that uses 2 data sets. I use an…DavidBlake 185 views 13 comments 0 points Most recent by Gregg Vadasz Reporting and Analytics for HCM -
Need help for building Confirmation Letter after probationContent Dear All, I am new to report development in oracle fusion HCM cloud. It would be really helpful if someone can post Confirmation Letter after Probation & Extensi…User_2025-02-06-14-37-05-233 106 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to see custom fields in OTBI?Content Hello experts, I have created a custom field in worker assignment page. How can I see custom fields in OTBI? Are there any batch processes to launch? Thanks in a…Valerio Curzi 66 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Agents querySummary Recipient / Specified UserContent Hi, If I set up an agent as a specified user i.e. (me), will the recipient who is located in a different region still only see …User_2025-02-05-22-44-35-842 36 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Embed a BI Publisher Report link in the Goals page to fetch data for the searched employeeSummary Approach to embed a link to run a BI Publisher report to fetch Goals details for that employeeContent Hi, Apologies if I had missed any existing thread/post on t…Kalyan Amaravathi 81 views 4 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Email address not accepted in scheduled BI Publisher reportSummary & in email address is preventing scheduling of BI Publisher ReportContent Hi, A colleague is trying to schedule a report but he is unable to enter an email addre…User_2025-02-05-22-44-35-842 36 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Passing values from report to an oracle fusion pageSummary Passing values from report to an oracle fusion pageContent I have a BIP report with bursting to email, which will be sent to the manager for individuals. Now in …User_2025-02-06-10-22-06-460 42 views 1 comment 0 points Most recent by Laksh Kapoor Reporting and Analytics for HCM
-
BI Publisher Termination ReportSummary Can a fix I made to the analysis version be applied to the Data Model version?Content Hi, Can someone please add the following Action Codes to this Data Model & …User_2025-02-05-22-44-35-842 55 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Need inputs to display data under "Calculated Time" section in OTLContent Hi All, As per the OTL setup we are referring two layouts while displaying OTL data. Initially employee will enter hours , Payroll time type, Hours and related f…Visu 47 views 4 comments 0 points Most recent by User_2025-02-06-14-40-18-938 Reporting and Analytics for HCM
-
Job field empty for one employee but filled for other employeeSummary In a report the job field for some employees is empty and for some it does contain informationContent I have created a report with two subject areas (workforce m…Inge Marinus 26 views 3 comments 0 points Most recent by Inge Marinus Reporting and Analytics for HCM -
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary =IF((Base SalaryContent SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (select salary_amount from cmp_salary where assignment_id=a.…User_2025-02-07-09-10-02-492 54 views 28 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary round(base_salary * 4.81%)Content SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (case when C.MIDDLE_NAMES is null then C.FIRST_NAM…User_2025-02-07-09-10-02-492 60 views 2 comments 0 points Most recent by User_2025-02-07-09-10-02-492 Reporting and Analytics for HCM
-
Analyses report to fetch Supervisor Level 2 and aboveSummary Analyses report to fetch Supervisor Level 2 and aboveContent Hi, I am looking to fetch the following using Analyses. * A list of Supervisors with Level 1 (not ma…Manoj.Gupta 52 views 6 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement …
-
Filled Requisition ReportSummary Need help troubleshooting a few things on a filled requisition reportContent Hello! Looking for some help troubleshooting the attached filled requisition report.…Jennifer Eichholz 47 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Assignment Overview with effective date (Report)Summary This report gives an overview over changes to assignments within your organizationContent The main purpose of this report is to give a manager or HR an overview …Even Kjorsvik-Oracle 80 views 0 comments 8 points Most recent by Even Kjorsvik-Oracle Reporting and Analytics for HCM -
Embed report into HCM My TeamContent Hi I would like to embed a report directly onto the MyTeams page for managers to be able to see some information for their team. Are there any documents for how …User_2025-02-06-11-18-47-896 77 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to report on what Permissions have been assigned to Reports/Data models in BI?Summary Is there a way to report on what Permissions have been assigned to Reports/Data models in BI?Content Hello We are in the process of reviewing our reporting acces…Helen Thomas 57 views 3 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Slow Performance when Department tree columns are includedContent We have built a simple report using ‘Goal Alignments Real Time’ subject area. The report runs in few seconds if we do not include Department tree columns. Howeve…User_2025-02-05-23-59-37-171 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM