Reports
Discussion List
-
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 31 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM -
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 215 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
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 19 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 46 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
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 136 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 36 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 38 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 45 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 118 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 -
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 588 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 106 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 87 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 436 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 28 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report on 20A approval data comparison featureContent I am trying to report on the new data comparison feature that was released with 20A. I want to be able to capture all of the approvals that are open along with t…Brandon Roberts 52 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are …Ryan_Sullivan 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce ManagementSummary Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce Management - Worker Assignment Real-Time subject areas in Fusion HCMCon…Mahendra 168 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fiscal CalendarSummary Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar.Content Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year …Chris Campbell 40 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated item for % assigned to courseSummary Learning DashboardContent I`m using a new calculated measure to work out the 'Capacity % Filled' for each of the courses but it won't calculate correctly. Any id…User_2025-02-06-11-18-47-896 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cost Center Manager SQLSummary I require the table/link for the cost center manager fieldContent Hi I am currently creating a report that requires the cost center manager field for a departmen…User_2025-02-06-00-21-58-611 50 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Can you find what fields are used in reportsSummary With upgrade to talent, how can i find the reports that the using the old fields?Lynn B 34 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 237 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Create Infolet icon is not available on homepageContent Hello Experts, I have enabled HCM Infolets tab in analytics section on homepage. However, I am not able to see Create infolet icon. I have seen couple of posts r…Hetal Vaghela 93 views 10 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Printable Department Hierarchy chartContent Hi All, Can someone share a sample for department hierarchy printable chart? I tried with the link https://cloudcustomerconnect.oracle.com/posts/9510552320 ,But …Nivya Mathire 71 views 8 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Recruiting OTBI Report: Job requisition completed: phase and status of candidate selected brigs an eSummary I´m creating a report listing all job requisition in phase open with state complete, cancel or closed and we need to show the name of selected candidate if are. …Christian_Kaladjian-Oracle 306 views 2 comments 0 points Most recent by Christian_Kaladjian-Oracle Reporting and Analytics for HCM