OTBI
Discussion List
-
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 263 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 590 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 41 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 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… -
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 47 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 45 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 436 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 40 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 52 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 68 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 -
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
-
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…user9020833 103 views 1 comment 1 point 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
-
Error when Editing Reports: Panel Div 'idView' not found in document oracleContent I've started receiving the error below when I'm editing reports. Has anyone seen this before? Panel Div 'idView' not found in document oracle Version 20AUser_2025-01-31-00-25-12-234 36 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to use FILTER USING function in edit formula in oracle otbiContent Hi All, Can anyone explain how this function FILTER(Column name USING() works in oracle OTBI. Regards, ShreyUser_2025-02-07-13-49-29-960 88 views 2 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Checklist Configurable Form ReportingSummary Pulling data from configurable form in checklistContent What is the best way to pull dff's that make up the configurable form within a checklist? After the 19B r…Shelly Feyerherm 371 views 7 comments 3 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Extract Month name in Oracle OTBIContent Hi All, Can we extract month name from any date by using any function in oracle OTBI. Except function monthname because it gives the month number not name. I wan…User_2025-02-07-13-49-29-960 705 views 6 comments 0 points Most recent by SantoshKumarBhairi 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
-
Get AOR Type and Scope in OTBIContent Hi All, I want the Area of Responsibility Type name and Scope( Wheter it is Business Unit,Grade or Department) in the oracle OTBI Analysis. Please let me know th…User_2025-02-07-13-49-29-960 42 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to get list of past 25 years from current year in OTBI ParameterContent Hi All, We want to display the list of past 25 Financial years in the oracle OTBI analysis parameter which will be dependent on another parameter. We have 3 para…User_2025-02-07-13-49-29-960 96 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM