Reports
Discussion List
- 
             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 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… 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. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM 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. 11 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… 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…user9020833 54 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM 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…user9020833 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 16 views 1 comment 0 points 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 16 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 69 views 10 comments 2 points Most recent by AMIT KUMAR YADAV 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 69 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 59 views 4 comments 0 points Most recent by Catherine Abi Samra 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 59 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 9 views 1 comment 0 points Most recent by Denis Magnan-Oracle 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 9 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 213 views 6 comments 0 points Most recent by Kevin M-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 213 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 … 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… 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 21 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM 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 21 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 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle 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 41 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 - … 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 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM 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 11 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… 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…
- 
             Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'… Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
- 
             SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             Burst Report By Managers and Email to Individual ManagersSummary Burst Report By Managers and Email to Individual ManagersContent Hello everyone, I have a requirement where I want to create a BI Publisher report that groups em…Daniel McMillian 447 views 9 comments 0 points Most recent by Karthick_Sathasivam Reporting and Analytics for HCM Burst Report By Managers and Email to Individual ManagersSummary Burst Report By Managers and Email to Individual ManagersContent Hello everyone, I have a requirement where I want to create a BI Publisher report that groups em…Daniel McMillian 447 views 9 comments 0 points Most recent by Karthick_Sathasivam Reporting and Analytics for HCM
- 
             Benefit:Certifications and Action Items tables informationContent Hi All, We have a requirement to fetch "Certifications" and "Action Items" tab related data in the BIP report. May I know in which tables holds this information … Benefit:Certifications and Action Items tables informationContent Hi All, We have a requirement to fetch "Certifications" and "Action Items" tab related data in the BIP report. May I know in which tables holds this information …
- 
             In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 61 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 61 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
- 
             Trouble converting Double to Decimal/NumericSummary: Attempting to create a BI report which creates a file for sending via SFTP to a 3rd party. When creating the Data Model, I'm able to use OBIEE in the SQL query … Trouble converting Double to Decimal/NumericSummary: Attempting to create a BI report which creates a file for sending via SFTP to a 3rd party. When creating the Data Model, I'm able to use OBIEE in the SQL query …
- 
             Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 31 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 31 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
- 
             How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following … How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following …
- 
             How should I define all parameters as multiple selection in sql report?Parameters are defined in this way in the SQL report I prepared.In this way, I can make more than one selection in the location with the parameters.But for example, when…Cansel Karasoy 41 views 12 comments 0 points Most recent by Stephan Steup Reporting and Analytics for HCM How should I define all parameters as multiple selection in sql report?Parameters are defined in this way in the SQL report I prepared.In this way, I can make more than one selection in the location with the parameters.But for example, when…Cansel Karasoy 41 views 12 comments 0 points Most recent by Stephan Steup Reporting and Analytics for HCM
- 
             Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 15 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 15 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c…Hi.itsa.me 95 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c…Hi.itsa.me 95 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
- 
             Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 107 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 107 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM
- 
             Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM