Reports
Discussion List
-
One report to view them all - person reporting showing department, assignment status etcContent Hi, Is there a SQL based data model that shows everyone in HCM, their assignment status, department, name, suffix, email, location, manager details, role details… -
Reporting on Student StatusSummary How to report on student status even if the contact is not a beneficiary or dependent?Content I have been trying to run a report to show all employee contacts th…User_2025-02-01-05-13-28-270 32 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Password protection for BI Publisher Excel outputsSummary Password at report levelContent Hi Team, We are in 18C and I have seen an option in BI publisher, Report properties, where we can setup a password for the Excel …Alvaro Couto 100 views 12 comments 3 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Seeded 'Line Manager Dashboard' - Deprecated since 19b onwards?Content Hello, I just heard from Oracle through one of the issue SR that the seeded 'Line Manager Dashboard' has been deprecated since 19b onwards. Is that true? Any alt…SantoshKumarBhairi 42 views 4 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Recreate BI Answers Direct Database Query reports using the OTBI subject areasSummary What is Direct Database Query Reports? Is this Datamodel OTBI? or what exactly?Content I received this email from Oracle and I want to know what's Direct Databas…User_2025-02-05-15-05-03-822 82 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How is Gross Earnings Calculated on Payslip?Content Howdy, How is gross earnings calculated on payslips? I would like to use the data for a custom report but cannot locate the table or data model it comes from. Th…David Rabalais 56 views 2 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Has anyone used @CalcMgrExcelSUMPRODUCT in business rule or member formula?Content We have a requirement to calculate the sum product in the formula and it should be dynamic based on the month selected by user. Following is the syntax documente… -
What's New in 19.10?Summary ... several things you're really going to likeContent Here we go again with another update. As always, I’m sure you’ve already memorized the latest What’s New do… -
Creating Report for Performance AppraisalSummary Our HR department requests a report to reflect performance appraisal for employeesContent Is it possible to get the following information below on a report. I wa…Dave Sherrard 55 views 5 comments 0 points Most recent by Dave Sherrard Reporting and Analytics for HCM
-
Need inputs to display More than 65531 rows in excel output by using Excel templateContent HI All, As per the requirement we developed Data Model and Excel template. While running the report getting below error, Waiting Time: 0.4 seconds Data Fetch Tim…
-
Inserting Last day of month in reportSummary Inserting Last day of month in reportContent Hi Champions, I have a specific requirement. I have designed reports in Web Reporting Studio and at the top of the r… -
Logo change in Org Chart ReportSummary How to change the logo in Org Chart ReportContent Hi all, We need to change the Oracle logo to client logo in the Org chart report. Navigation: Navigator--> Me--…
-
Leave accruals and usage by absence typeContent In our legacy system we had a report that listed, by employee, all leaves that were accrued and all absences taken, by leave type, sorted by date. Is there a rep…Annette M 63 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Add filter to analysisContent I created an analysis that prompts for a date paid. I would like to further filter the analysis using the prompted date paid and check that it is > then a start …Annette M 67 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Relative Date Filter for AgentSummary How do you put a relative date filter on an agent for an analysis?Content When creating agents for analyses, we would like to have agents that run with prompted …User_2025-02-04-06-02-17-038 56 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Build a FRS report across prior eleven periods and Years once user enters particular period and yearContent Hi Experts, Our client has a requirement to build a FRS report showing prior eleven months and corresponding year of prior eleven months once the user entered th…User_2025-02-01-07-41-50-723 62 views 2 comments 0 points Most recent by User_2025-02-01-07-41-50-723 Planning
-
Need help on BI Publisher ReportSummary Creation of Dashboard promptContent Hi Team, I am creating one report using data model and report with parameters. When I tried to create Dashboard prompt for th…SM-Oracle 81 views 14 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for HCM
-
Need Contnous Running Numbers on InvoicesSummary Web Reporting Studio - Continous Numbering requiredContent Hi All, We are using one instance or PCMCS for Invoicing purpose. We have generated some reports as in…Amit Agarwal-158816 27 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Unable to find cost centre in OTBISummary I am unable to find cost center number in OTBIContent Hi, Our Cost Centre is within PAY_COST_ALLOCATIONS_F.Segment 2 within BIP. We can also view this with in HC…User_2025-01-30-03-54-32-528 123 views 4 comments 1 point Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Productivity ReportSummary A Report from Oracle to provide site productivityContent Can i ask if a report like this is possible? They are looking to measure productivity in the sites, so t…User_2025-02-04-17-26-38-144 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Looking for Seeded report to identify campus candidates and to pull list of screening questions withSummary Looking for Seeded report to identify campus candidates and to pull list of screening questions with their responsesContent Hi Team, Is there any seeded report w…Harish Kumar Kovi 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table link between Profile attachments and UCM fileSummary Finding Profile Related attachment in UCMContent When you upload an attachment in your profile that goes to UCM as a file attachment. But the name of the file ne…Prateek Parasar - GTUK, ACE Pro 41 views 1 comment 8 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to run report in Oracle BISummary Unable to run report in Oracle BIContent Hi, We suddenly have issue with all our reports in Oracle BI Production. We are not able to run our reports at all. Does… -
Is there a back or undo button in OTBI?Summary Is there a back or undo button in OTBI?Content We are implementing Oracle this year and I was wondering if there was a back or undo button in OTBIUser_2025-02-05-07-51-01-504 43 views 6 comments 1 point Most recent by User_2025-02-05-07-51-01-504 Reporting and Analytics for HCM
-
Need filter condition in OTBI to pull the employee who having and not having Work email detailsSummary Employee Details those Having Work Email and not having Work EmailContent Hi Team We have a requirement to pull the OTBI report who having Work Email and don't h…
-
Smart View “No Data / Missing” Option Suppressing ZeroesSummary The latest Windows version of Smart View incorrectly suppresses zeroes when “No Data / Missing” suppression is selected in the Smart View Data OptionsContent It …Irina Feldesh, CPA, CGA 290 views 9 comments 1 point Most recent by Irina Feldesh, CPA, CGA Planning -
BI Cross Report from External Source and HCM RecordsSummary Create a Report from external source file as XML or CSV data file in WCCContent Create a cross report with External data source file in Web Content Center and pe…Misael Gutiérrez-Oracle 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Alert composer not listing ResourcesSummary Resources not being shown when trying to create an AlertContent Hi I hope you are doing well. I'm having some issues setting up Alert Composer. At this moment we…