Reports
Discussion List
-
Future Starters / Pending WorkersSummary Need a list of pending workersContent Hi I'm trying to build a simple report that shows all pending employees (yet to commence employment). Which subject area sh…User_2025-02-05-22-44-35-842 85 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast FormulSummary Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast Formula)Content Many a times we may have a requirement that we woul…AshishERPCloud 103 views 2 comments 7 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Involuntary Turnover ReportSummary Involuntary ReportContent Hi, I'm trying to build a report from scratch that will show the number of involuntary leavers and their reasons (e.g. redundancy) etc …User_2025-02-05-22-44-35-842 29 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM
-
Separator between Bars in Charts - Possible?Summary I have a requirement of adding a separator line between the bars for Dec-18 and Jan-19 to bifurcate the years. Screenshot attached.Content Can anyone please tell… -
Date Prompt QuestionSummary As Of Date Prompt QueryContent Hi, I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain …User_2025-02-05-22-44-35-842 54 views 28 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
user unable to see reports in a folderSummary user unable to see reports in a folderContent User is not able to see reports in any folder. Even in My Folders. It is just blank. Could see only folder structur…Anuradha T 251 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Overlap Bar Chart - Possible?Summary Is it possible to design a bar chart with second bar overlapping the first bar. Screenshot attached.
-
Parent Child Hierarchy is not showing in HFRContent I took idescendants of prompt of cost centre in the row but while previewing it showing child first and then parents member. I want to show parent first and then…
-
Is there any option to change field name in Data VizSummary Is there any option to change field name in Data VizContent Hi Gurus Is there any option to change the field label in Data Viz (OAC). Like in data set column nam…Saptadip 18 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Area of Responsibility - Work Contacts - Table NameSummary Area of Responsibility - Work Contacts - Table NameContent Where the work contacts (Area of Responsibility) are stored in the database. If you know they are stor…SAKTHI SUNDAR 45 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to integrate Narrative Reporting with Non-Oracle Sources?Content Can anyone please tell me how can we integrate Narrative Reporting with Non-Oracle Sources? Any response will be much appreciated. Regards, Nrupansh Joshi Versio…
-
How to add a date promptSummary I would like to add an 'As At' date prompt to an existing basic employee analysis reportContent Hi, I'm relatively new to OTBI and unable to add a 'as at' date p…User_2025-02-05-22-44-35-842 145 views 14 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Previous and Current values for a shift, crew, rotation beginsSummary Due to Covid-19 we have had to introduce new shifts for our job sites. Need to report both current and previous values for auditingContent I have been tasked wit…User_2025-02-04-08-51-08-912 35 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get the last incumbent date for vacant positionsSummary Trying to get details on vacant positions as to when it was last filledContent Looking to get whether the position ever had an incumbent and if so what the last …Mario B 57 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to count number of Management layers between an incumbent and the top of the organizationContent Looking to find a way to count all the management layers between employees in an organization. Have been able to do a span of control report but need to count ho…Mario B 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…James Hoffmann 117 views 22 comments 1 point Most recent by James Hoffmann Reporting and Analytics for HCM
-
Server Message Block(SMB) protocol in BI ServerSummary SMB protocol to connect to Active Directory serverContent Hi All, We would like to send a CVS report from our HCM BI Server to AD server. Our AD team has asked u…Alvaro Couto 18 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM -
POV missing for FR reports when used in CardsSummary POV missing for FR reports when used in CardsContent Hi I am having an issue across multiple clients post this months patching, we picked it up in test last week… -
Performance Document Submission Date and HourContent Hello experts, How can I track the Performance Document Submission Date and Hour in reporting? Are there any field in OTBI reporting that allow me to get these i…Samanta Lorando 14 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM
-
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 674 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
SQL query time out error in BI ReportsSummary Getting SQL query time out error in BI ReportsContent Hi Experts, We are getting SQL query time out error in BI Reports. have made changes Query Time out to 1000…User_2025-02-06-19-27-47-357 120 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Job seniority date reportSummary Job Seniority Date reportContent I just created a rule in "configure seniority date" section for job, level workrelationsihp. Then i ran the populate process aga…Adil_R 111 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Identify in the Learning Catalog a learning item corresponding to a SCORM objectContent Hi, I have imported in the "Learning Catalog" some courses provided by Skillsoft. When a learner does a course, in the SCORM tables (those starting with WLF_SCOR… -
Line Manager Dashboard DocumentationSummary Line Manager Dashboard DocumentationContent Hello, Is there documentation available for details of the dashboards available in HCM like Line Manager Dashboards. …Murthy Kodavati 504 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SV: FR report decimal number customisation does not save after a REFRESH of the reportContent Hi all When we open a Financial Reporting in Excel, and change the data display to a customised number (we do not want to see the decimals in the grid), it works… -
Payroll run Costing Results informationSummary We are trying to display Costing results information after Payroll ran.Content Hi All, We are able to get the Payroll run costing results through "Payroll – Payr…
-
Custome Talent Profile Printing Sections that Employees Don't Have AccessContent We have created custom Skills and Qualification Print. First we have taken a copy of delivered RTF template and a copy of delivered data model and have created a…Misbahul Khair 27 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM