Reports
Discussion List
-
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by… -
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include …MilanMohanty 23 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
OTBI: How can we run a report with the previous month start and end dateSummary: How can we programmatically run an OTBI analysis report with the previous month start and end date? Content (please ensure you mask any confidential information…SUSAN SANDIFER 177 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Filter query using NVL not workingSummary Unable to save query when trying to use the NVL command with a logical sqlContent Hi All, I hope someone is able to help me with an issue that I am having. I hav…User_2025-02-04-08-51-08-912 88 views 10 comments 0 points Most recent by Tharuka Reporting and Analytics for HCM -
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Most recent date paidSummary: I have an OTBI report that runs every other Thursday pulling earnings. The Effective Date field uses the below advanced SQL filter to pull only the current date…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to report on workers with termination date in last two monthsSummary: Content (required): I'd be grateful for some help with a filter on an OTBI report. The report is quite basic, showing employee name, person number, position, lo…Leanne W 826 views 7 comments 0 points Most recent by anusha chunduru Reporting and Analytics for HCM
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…Farah Alajou 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…Welsey 112 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 32 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 55 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Connect Query Tool to Oracle CloudSummary New to reporting in the Cloud and am interested in finding more efficient ways to view the contents of our tables.Content We are in the process of transitioning …User_2025-02-04-12-36-46-802 83 views 6 comments 3 points Most recent by KDR Reporting and Analytics for HCM
-
Is it possible to report on payroll costing data with the position that the cost relates to?Summary: We have a business need to be able to separate out costs for a position change and to be able to report on them separately, but the data table only holds the as…
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
UK Payslip: Is there any approach to trigger payslip only for employees who have work email.Summary Payslip Process Completed with Warning : Many employees do not have email id and we are trying to send payslip as email through bursting option, in such scenario…
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…E McDonald 54 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…Tina T 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to hide unnecessary buttons from OTBI Dashboard?Summary Is it possible to hide unnecessary buttons from OTBI Dashboard?Content I designed an OTBI dashboard, which when I run shows OTBI Header buttons and search option…Dharmendra Shukla 73 views 10 comments 2 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Trying to pull Comments from Mid-Year Performance document into a reportSummary When Employee/Manager Comments fields are added to performance report, errors outContent I have a request to pull a report of all Goals and include the Employee …User_2025-01-28-20-43-56-568 60 views 4 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
-
Is it possible to add candidate Hire date using OTBISummary: We have a requirement to include hire date in the report. The intention of the report is to capture all offers that are created, even if they don't end in hire.…Christina Roy 17 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Excel Template error 'Maximum active cells allowed in a template is 100000'Summary: Hi Team, We are trying to create a report using the Excel template since there are a lot of tabs expected in the Excel output. We are getting the error 'oracle.…Tanu Shri Patel 216 views 6 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Would it be possible to further understand the HR Dashboard - Birthday Reminders tab?Can we have support on the following for this Birthday Reminders tab in the HR Dashboard? https://fa-eups-saasfaprod1.fa.ocs.oraclecloud.com/analytics/saw.dll?Dashboard …
-
HR Dashboard - Compensation Tab - Where to find where data is coming from and how to hide data?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know where this data is being pulled and if there can be an extract of the data? Th…
-
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 22 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI report only showing an individual's supervisor and managerSummary: I have a requirement to create a report showing each workers named supervisor and line manager (mostly these are the same person, but in some cases they're diff…Rich M 44 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 13 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
How to add Analytics section to homepageWe've been trying to embed some infolets on our Oracle Cloud homepage, however it appears that most users (at least it seems that way based on Cloud Connect posts, YouTu…