OTBI
Discussion List
-
Has anyone created a custom role for staff outside of HR to access other staff addresses?Summary: Content (please ensure you mask any confidential information): I am still figuring out how to create custom job roles for HCM, but I am hoping someone that has … -
Issue in adding Ethnicity Column.Summary: Hi All, I have an OTBI report that tends to fetch all the performance details of an employee, we are trying to add ethnicity column in the report with formula: …Sushant95-Oracle 13 views 0 comments 0 points Started by Sushant95-Oracle Reporting and Analytics for HCM
-
Need inputs to handle NULL values in OTBISummary: Need inputs to handle NULL values in OTBI Content (required): In case if an employee doesn't have Visa permit record then we are getting value as 00--0 in the O…
-
OTBI Report - Advanced Query - presentation variable is null, how to handle?Summary: In OTBI Report, I have used Advanced Query to combine multiple subject areas. As a parameter I'm using presentation variable. If the presentation variable is pa…
-
Reports on Generative AI Usage and AuditsSummary: Reports to get data on Generative AI Usages and feedback. We are implementing Gen AI for feedback generation but need reports to understand GenAI feedback and U…
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…Ian.Gooderham 25 views 7 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP reportSummary: Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP report Content (please ensure you mask any confidential information): We have…
-
Convert Date to Mon-YY Format in Edit FormulaGood Day, Is there a way to convert date column to Mon-YY format in edit formula instead of using Column Properties > Data Format? Thank you.
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how … -
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User …
-
Count of All Performance Goals is not showing properlySummary: Hello, can you pls check my filters below. The Count of All Performance Goals is not showing properly so I added the Goal Status filter but still not showing up…
-
SQL query that brings the fields to HDL for CostCenter?Summary: Content (please ensure you mask any confidential information): Does anyone have a SQL query that brings the fields to HDL for CostCenter ? Simple with the minim… -
OTBI Managers and Direct Reports Additional FieldsSummary: I need to create a report that summarizes the span of control for job levels that have direct reports. Looking for the right fields to use. Content (please ensu…
-
Historical Location Data Workforce Learning - Learning Records Real TimeSummary: Content (please ensure you mask any confidential information): We have started to move our reports to the Workforce Learning - Learning Records Real Time as the…Jeremy CSC 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Absence Date Start in OTBII created a report using Workforce Management - Absence Real time that shows absences employees have along with the date created, and date start of the request. I notice…
-
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount…Ayoub AFRASS 11 views 2 comments 0 points Most recent by Ayoub AFRASS Reporting and Analytics for HCM -
Length of Service based on Rehire date calculationContent I am trying to calculate Length of Service based on employee's latest hire date. I used Workforce Event Real Time subject area to calculate the rehire date (usin…Riti Malhotra 128 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to bring HCM UDT Columns into Fusion OTBI subject areaSummary: Need to access the UDT columns (HCM) in OTBI standard subject area's instead of using the "Payroll - User Defined Tables Real Time" as a separate subject area. …
-
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o…
-
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 22 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version…
-
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 16 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" subject areaSummary: Duplication of "manager question text" and "manager response text" in "Workforce Performance-Performance Check-in Real Time" subject area. Content (required): A…kayoung lee 92 views 2 comments 0 points Most recent by Ilaria Petrosino Reporting and Analytics for HCM
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…
-
Exclude Bank Holidays from Absence Days calculationSummary: Bank holidays are counted in the absence days calculation for a sickness absence but should be excluded Content (required): We have a number of sickness absence…Dawn Cawston - CPS 106 views 22 comments 2 points Most recent by Dawn Cawston - CPS Workforce Management -
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident…
-
OTBI delimit data from 1 column into multiple columnsSummary: We have a report requirement where we want to delimit output from 1 column into multiple columns based on '/' delimiter Content (please ensure you mask any conf… -
Work Schedule future dated rows not joining correctly OTBISummary: We have a report comparing the work schedule vs the work schedule assignment. Work schedule (Assignment real time) Work Schedule Assignment ("Person Schedule As…
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the …