Reports
Discussion List
-
Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?Gowri Perumal 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 111 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM -
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our…Clare Murtagh - new 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…Monique Dias 124 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…Helen Thomas 11 views 4 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Seeded Head Count Reports Not WorkingSummary: We have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. Content (please ensure you mask any confident…Vibha Pandey - Oracle 31 views 3 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Scheduled classes not available in Learning Calendar Summary dashboard?Archived Learning Calendar Dashboard from Oracle demo instance. and unarchived dashboard in our instance. Data is displaying like this but, in oracle demo instance it is…YAMINI DANTOORI 21 views 1 comment 0 points Most recent by AmyLopesNF Reporting and Analytics for HCM
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.
-
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co… -
Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 111 views 3 comments 0 points Most recent by Madhavi.Modala Reporting and Analytics for HCM
-
How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta…Dan_Hinsley 21 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 112 views 15 comments 6 points Most recent by Radouane Allam Reporting and Analytics for HCM -
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…
-
Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav… -
Can Employer Comment under Termination Details be on a report?Summary Is there a way to add the Employer Comment informaiton to a reportContent We list the company that an employee leaves us for in the Employer Comments box on the …Denise Jo Crangle 86 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 139 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 44 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 11 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Filters on evaluation deep linkSummary: Filters on evaluation deep link Content (please ensure you mask any confidential information): I have the following deep links: Evaluate Performance (EVALUATE_P…Stefano_Mazzocca 13 views 1 comment 0 points Most recent by Senthil Murugan Balasubramanian Reporting and Analytics for HCM -
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 112 views 5 comments 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM -
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo…Jose Guerra 2 views 1 comment 1 point Most recent by Gillian Kilbride Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 31 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 143 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM
-
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 17 views 2 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 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM