OTBI
Discussion List
-
Enabling HCM seeded Infolets in R11Summary We are in R11 and trying to enable Infolets by creating a Sandbox > Structures > Set system options and enable InfoletsContent We are in R11 and trying to enable…GopiKAutomus 195 views 4 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 70 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to improve the performance of OTBI dashboards and reportContent Hi, We have created a custom dashboard. And few reports are taking long time to respond. Can someone tell me how can I improve the performance of Dashboards and …Nivya Mathire 92 views 12 comments 0 points Most recent by Rizwan Basha Reporting and Analytics for HCM -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 28 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 83 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM -
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …Salma Mohamed Salem 24 views 1 comment 0 points Most recent by Alexandru C. -Oracle Reporting and Analytics for HCM
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Offer ID not showing up on Recruiting Real Time Subject AreaSummary: Offers created under a requisition, but Offer IDs not showing up on the backend Recruiting Real Time subject area. Content (required): For a particular requisit…User_2025-07-18-13-29-11-469 70 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 18 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Reporting on Eligible for Pretax Age Catch-Up Contributions FieldSummary: Looking to include the column Eligible for Pretax Age Catch-Up Contributions in a payroll report to pull all data assigned to a person's Reporting Information c…Emily Meyer 32 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve…Girish Bhatia 41 views 7 comments 0 points Most recent by Girish Bhatia Reporting and Analytics for HCM -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 5 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How do I remove unwanted commas in OTBI report outputSummary: Custom address field column contains extra columns when source column is null Content (please ensure you mask any confidential information): I have created an O…DennisOliver 34 views 5 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A… -
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 23 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Release 13 - Annoyingly hidden folders menuContent Hello, Since R13 the Reports and Analytics page has changed, and annoyingly the folders are hidden and have to click an icon to view them, when they load they do… -
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 37 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
Display multiple emails/phones on one row when there ae multiple records of the same typeSummary Multiple emails/phones with multiple recordsContent Hi All, I have built my query for displaying employee information with their different emails and different p…User_2025-02-04-08-51-08-912 35 views 2 comments 0 points Most recent by Kuldeep Gawali Reporting and Analytics for HCM -
Workforce Management - Worker Assignment Event Real Time - Assignment FTESummary: We want to achieve below requirement using OTBI. Can we get FTE and leaving reason from the same SA or need to join other SA to get the data ? Can we get Assign…Jatin_Maru_1 32 views 2 comments 0 points Most recent by Jatin_Maru_1 Reporting and Analytics for HCM -
Can we report on users with no work schedule using OTBI analysis?Summary: Users with no work schedule not showing on OTBI analysis of work schedules by user. Content (please ensure you mask any confidential information): I have an OTB…
-
Date Calculation formulaHi, I've a requirement where I have to show some data based on future dates and also print dates like First Calendar Date of Next Month, Last Calendar Date of Next to Ne…Ninja 16 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Track changes to Primary National Identifier (social)Summary: Track changes to social (Primary National Identifier) Content (required): Have a requirement to identify changes (within the last 30 days) to a person's Primary…
-
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 16 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 50 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 32 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM