OTBI
Discussion List
-
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 -
OTBI - Limit results in a bar graph only out of 10, but not on dataSummary Limit results in a bar graph only out of 10, but not on dataContent Hi all we build a report with several graphs. For the attached graph we need to list the top …Nicola Petri 59 views 5 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 113 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
filtering by custom promptSummary We setup a custom prompt but we need to understand how to link into filtersContent Hi Ladies & Gentlemen, we configured a custom prompt based on following SQL co…Nicola Petri 54 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle 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 139 views 14 comments 0 points Most recent by User_2025-02-05-22-44-35-842 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 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify employees who haven't created any performance goals and those who haveSummary Looking to create a quick reference report for Division heads to see which employees have created goals and which have notContent I have been trying to use the G…Mario B 172 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Using external data in OTBIContent Hi folks! help needed! We are implementing a manager dashboard, where we need to use default expense account field. As confirmed in the following post…Nicola Petri 41 views 3 comments 0 points Most recent by Sahil Makhiza 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
-
Daily Breakdown ProcessSummary Workforce Management Absence Calendar Details Real TimeContent Hi, I've received a request to build an absence report using the 'Workforce Management Absence Cal…User_2025-02-05-22-44-35-842 37 views 8 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Create a prompt on a calculated fieldContent Hi, can you suggest a way to create a prompt based on a calculated field? Thanks a lot! NicolaNicola Petri 26 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM
-
The Data is of zero or negative value and cannot be displayedContent Hello, Is there a way to customize/change the message which returns when a column result is zero? 'The Data is of zero or negative value and cannot be displayed'…Susan Anderson 32 views 4 comments 0 points Most recent by Susan Anderson 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
-
Cost Allocation - KFF setupSummary Provides step by step points on how to configure and manage the Cost Allocation Key Flexfields.Content To generate costing results for your payroll run results a…Tanvi Jain-Oracle 262 views 3 comments 4 points Most recent by Sricharan Monigari 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 643 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
00/00/0Summary Cannot filter on report returnContent Hi all I am looking at working pattern reporting. All our full time standard working hours peeps inherit their working patt…Dawn Cawston - CPS 36 views 7 comments 0 points Most recent by Dawn Cawston - CPS 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 86 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… -
Seniority Dimension OTBI ReportingSummary Seniority date dimension added in 19D for V3 seniority datesContent Hello, 19D introduced a new dimension for Seniority Date reporting, specifically for use with…Whitney Van Way 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI > Workforce Profiles – Person Profile Real Time > Cannot count the Persons in different years bContent Hello, We have created the following analysis (PFA S1) The field “Years of Experience Band” first computes the total years of experience by calculating the sum o…
-
A simple SQL created using the Create Analysis from Simple Logical SQL is not working as expectedSummary A simple SQL created using the Create Analysis from Simple Logical SQL is not working as expectedContent We have tried a simple sql : SELECT B.Content_Item_Id FR…Sreedharan-Oracle 44 views 2 comments 0 points Most recent by Sreedharan-Oracle Reporting and Analytics for HCM -
Connecting Worker Assignment and Comp Salary work areasSummary Connecting Worker Assignment and Comp Salary work areasContent Hi ALL, I'm need fields from "Workforce Management - Worker Assignment Event Real Time" ."Assignme…User_2025-02-07-19-03-14-525 23 views 7 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Details of run of the analysisSummary Report to know the details of the run of the analysisContent Hi, Is there an out of the box report that will show us how many times an analysis has been run? By …SM-Oracle 25 views 5 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Is Seniority Date subject area available in 19D release?Summary Is Seniority Date subject area available in 19D release?Content Hello Team, We have a requirement to get the Seniority date using OTBI report. We found that ther…Harish Kumar Kovi 66 views 11 comments 0 points Most recent by Whitney Van Way Reporting and Analytics for HCM
-
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 454 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to fetch records with valid primary phone in OTBI analysisSummary In OTBI, How to check if all characters in phone number field is numericContent Hi, In OTBI analysis, I have a requirement to fetch employees whose primary phone…RekhaPK 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tips for improving performance of an AnalysesSummary Tips for improving performance of an AnalysesContent Hi, We have parameters - Person number and Learning Type, but the report takes forever to give the output. I…Manoj.Gupta 51 views 1 comment 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM DeeplinkSummary Deeplink to view absence recordContent Has anyone created a deep link in a report to view an absence record?User_2025-02-05-23-02-10-916 66 views 2 comments 0 points Most recent by Gail Langendorf-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…
-
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