Reports
Discussion List
-
Report to Audit Approval Rules ChangesSummary: Just trimmed back access to Transaction Console, but would like to see who made the most recent Approval Rules changes to workflows, and when the changes were m…Jessica D 535 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Can you use wildcards in a CASE statement?Summary: I have an analysis where if the Job Name is like 'abc%', '%hpr%', then I want to display certain text. Note that there are multiple wildcards, some only before,… -
Report Job Offer Employment Category in AnalysisSummary: I want to Report the Employment Category of a Job Offer in an Analysis Content (required): I use the Subject Area "Recruiting - Recruiting Real Time" and can't …Felix2 12 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI?User_2025-01-25-03-18-49-935 98 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is…Cansel Karasoy 42 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Manage IBAN with REST APISummary: Content (required): Hello everyone, We are having issues using the REST API to add an IBAN for a waiting employee/worker. In particular, we have developed a cal… -
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 333 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM -
How many WorkEmails can we add to a filter while creating a Filter in Alert ComposerSummary: Trying to add work Email Id's to an expression using 'OR' operator. Has anyone used it before and know how many emails can we use in one batch. Content (require… -
Looking for table for salary change action and reasonSummary: Looking for table for salary change action and reason Content (required): Which table holds the salary change reason and action? This is not the same table whic…Parag Hiremath 1.4K views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Salary Increases reportSummary Report to show increases to salary with date and reasonContent Hi, has anyone created a report, (guessing it would need to have been done in BIPublisher?), to re…User_2025-01-22-19-30-53-101 250 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
GETTING ERROR WHEN USING TWO SUBJECT AREASummary: I HAVE ONE SUBJECT AREA "Procurement - Procure To Pay Real Time'' I SELE CT PO NUMBER , CREATION DATE , CLOSED DATE, AND FROM ANTHOR SUBJECT AREA ''Procurement … -
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…Julia SRI International 465 views 9 comments 0 points Most recent by RamyaK Reporting and Analytics for HCM -
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…User_2025-01-25-00-37-41-739 201 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time - zero results when adding person numberSummary Zero results when from including different fields from same subject areaContent I hope this is one of those obvious "doh" moments. Subject Area: Payroll - Elemen… -
How to Capture a Work at Home Flag Change in a report?Summary: Content (required): Hello Experts, We need to report on instances when employee's Work at Home flag changes from 'no' to 'yes' and from 'yes' to 'no'. Does anyo… -
Can a column name be modified but also translated?Some standard colom names are not suitable for our organization but if I change them the name will be fixed. For example if I change the language settings the name of th… -
Attrition and Turnover ReportsSummary: Need to develop an analysis for Attrition and Turnover Content (required): We have a below requirement for Attrition and Turnover Reports, can anyone share the …Raghavendra M 646 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…Izliana 31 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…Prajwal kumar 77 views 5 comments 0 points Most recent by Prajwal kumar Reporting and Analytics for HCM -
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…Sinem Kara 54 views 9 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check… -
Percentage of documents in various tasks.Summary: Hi Experts, The performance process flow we are using is 1) Set Goals 2) Self evaluation (employee) 3) Manager evaluation 4) Employee final comments 5) Manager … -
How can I edit the pie report I added to the Dashboard screen?The pie report I prepared shows the gender information of the people working in the departments. For example, when I click on the number of women, the page in the screen…Cansel Karasoy 42 views 5 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete…Barış Ergün 73 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can I make the report not open without selecting Parameters on the Dashboard screen?I have a few reports that I have prepared from analysis and I have created a dashboard from them. And reports work with parameters. When I click Open to Dashboard, repor…Cansel Karasoy 51 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is it possible to open a detailed report for a tile or graph besides it?Summary: Is it possible to open a detailed report for a tile or graph besides it? When I am using action links in Interaction tab detailed report is getting opened in th…Parul Sah 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 102 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 220 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…Dona Das-Oracle 1 view 0 comments 1 point Started by Dona Das-Oracle Reporting and Analytics for HCM -
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi…Shanna Oppenheim 1K views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM