OTBI
Discussion List
-
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any … -
Converting UTC to EST time zone in Logical SQLSummary: Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax. Cont…Denise Izzi 2.5K views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Aggregate function in OTBI AnalysisSummary: Please share some documentation on using various aggregate functions on any column of an OTBI analysis Content (required): Need to use aggregate functions acros…Hem 378 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
OTBI reports to replicate delivered reports in Workforce Compensation > Pay for PerformanceSummary: Workaround solution following 21D release "improvement" Content (required): It has been decided by Oracle to disable reports in order to improve the performance…Amandine C-Oracle 32 views 1 comment 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Analysis with Approval Notification Data (Initiated/Approved dates) for terminationsSummary Creating an OTBI for terminations that include the Initiate Date and Final Approval Date from Approval Notification Subject areaContent Hi, We have an OTBI Analy…Denise Izzi 101 views 6 comments 2 points Most recent by Denise Izzi Reporting and Analytics for HCM
-
Security for OTBI ColumnsSummary Security for OTBI ColumnsContent Is it possible to Apply Security around specific columns in an OTBI Subject area? The current understanding is access to Subject…Harish Kumar Kovi 105 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard over a Mulitple assignment HCM config - need to eliminate wrong result from dashboardSummary: VP is seeing an Indirect reports Director that is outside of Talent/Performance Goal Drill-down compared to User Interface for Performance and Goals (Talent) Co…John White-Oracle 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 42 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Error When Trying to Save Agent (Scheduling a Report)Summary: I am getting this error "The following error occurred: Oracle BI Scheduler Error: [nQSError: 12017] Unexpected socket read timeout: connection terminated by net…Erin Hamrick 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Session Variables for Recruiting Subject AreasSummary: We have an open requisition report that we would like to use a session variable for so that the recruiter who is viewing the report only sees their requisitions…Allison O'Brien 83 views 2 comments 0 points Most recent by Allison O'Brien Reporting and Analytics for HCM -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! Upda… -
How can i create a current and previous report for location change for a dashboard?Summary: I need to create a location change report using the visa permit type (not null) in the Person Real Time subject area and the Assignment Event Real Time subject …Mark Stoker 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Ethnicity ReportingSummary: Event headcount is incorrect. Showing 2 when employee has more than one ethnicity selected. Content (required): I'd love a second set of eyes on this. On recomm…Susan Anderson 136 views 2 comments 0 points Most recent by Christine Tutani Reporting and Analytics for HCM -
How to create an advanced OTBI reportSummary: Short video describing how to create an advanced OTBI report using a calculated column and binning. Content (required): https://www.youtube.com/watch?v=YNcSgOvw…Julian Challenger-Oracle 31 views 0 comments 3 points Started by Julian Challenger-Oracle Reporting and Analytics for HCM -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro…Faizan Rashid 21 views 1 comment 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Report on scheduled Extracts and BI reportsHow to get a report on all the extract and BIP reports scheduled in system with frequency of schedule? Regards, NivyaNivya Mathire 21 views 1 comment 2 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Goals Report showing Draft StatusSummary All Drafts Status Goals before a certain dateContent Hi, I've been asked to build a report that shows anyone who had a 'Draft' status to their 2020 Goals prior t…User_2025-02-05-22-44-35-842 41 views 4 comments 0 points Most recent by Lavanya Reddy Reporting and Analytics for HCM
-
Pull data for a specific person number when there are multiple Person numbers in the dataSummary: I am trying to pull management level for the manager's job vs the employee using OTBI report Content (required): I am using workforce assignment real time - how…Riti Malhotra 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue-Line Manager getting employee's all assignments performance documents details in OTBI reportSummary: I am working on one OTBI report to fetch the details of performance document for line manager. Employee who are having two Active assignments and both assignmen…Kamini Kaushik-Oracle 30 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to get the employees' latest assignment data and the effective start date of the TOS position thSummary How to get the employees' latest assignment data and the effective start date of the TOS position through OTBIContent Hello, I'm trying to create a report using …Rajesh Kumar Bhagtani 66 views 2 comments 0 points Most recent by Gayathri Ganesan Reporting and Analytics for HCM
-
PERIODROLLING for Annual TurnoverPERIODROLLING for Annual Turnover I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) . …
-
Security profile to restrict line manager to view only one assignment of employees in OTBI reportSummary: Hi All, My line manager is able to see the records for performance document for all Active assignments of employees. How to restrict my OBTI output so only the …Kamini Kaushik-Oracle 32 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to fetch details of bypassed task for performance document in OTBI reportSummary: I have requirement to fetch the details of bypassed task in performance document in column Content (required): In our instance for performance document the work…Kamini Kaushik-Oracle 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 33 views 1 comment 0 points Most recent by Preston Schultz Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Remove Person number From Human Capital Management - Approval Notification Archive Real TimeSummary: In Subject area Human Capital Management - Approval Notification Archive Real Time, column Subject "Approval Notification Details"."Task Title" can we remove Pe…RakeshK 32 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM