OTBI
Discussion List
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience… -
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…
-
Is there a report or SQL that will show all Miscellaneous transaction carried out on Inventory ItemsSummary: There will be an upcoming audit in our client's organization. Is there a seeded report or SQL query that can display all Miscellaneous transaction reports condu…
-
Total Salary by Division for the first of each month - OTBISummary: I feel like maybe this is very obvious and I'm overlooking it. But here it goes: We want a report that total salary for a given division on the first of each mo…Monique 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…Morten Graae 542 views 4 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
Learning OTBI - Manage Default Access infoContent Hi there, is it possibile to extract the Manage Default Access info (course level) via OTBI? We would like to display the Self-service settings > view mode, plea… -
Actual Effort Attempts ReportSummary Tracking report on self paced activities with the actual training effort for every attemptContent Hello there, We need a tracking report on self paced activities…
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 112 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Deep link for a reportI have created a new page entry under "My Team" and i want a report to be triggered when someone clicks on that. Screenshot attached. How can i obtain the link to a repo…Girish Bhatia 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 21 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal …Clifford Trett 21 views 1 comment 0 points Most recent by Chris Ford Reporting and Analytics for HCM -
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…ammiano 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
Learn Admin view on Workflow ApprovalSummary: Dear Community, Is there a way for Learn Admin to view on Workflow Approval? Currently Transaction Console is granted only to IT Admin. Worklist is not able to … -
Audit ReportHi Experts, Can we have an audit report in the system on employee details change which included any change relevant to employee assignment, DOR and personal info etc.
-
Job Code Usage ReportIs there a report shows the last time an associate was in a given job code. We have a number of job codes with no one in the title. It would be helpful to know if the jo…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Emergency Contact and Employment Info ReportSummary: Hi all. I've reviewed the documentation shared in other posts, but I'm still not getting there, for some reason (likely user error!). I need to create a report …Jessica D 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to show an Assignment Completion Date and its Renewal Assignment Date in a Report?Summary: We have a CPR Course. We need to show when someone's completed the course and when their renewal assignment will start. Is this even possible? Content (required…
-
How can I create a historical overview from a flexfield CHARACTER Data type?I have data information stored in a CHARACTER data type flexfield. To expose it in an analysis in Oracle Business Intelligence (OITBI), I navigate to the 'Incentive Comp…Priscila Banqueri 11 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Matrix Manager - Why does OTBI return multiple matrix managers for each employeeSummary: We use Line Manager and Compensation Manager when creating or updating an employee assignment. Our reports should return no more than two managers for the curre…Michael Grant 161 views 6 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM -
How to filter for Finalized territories in Sales - CRM Territory Resource subject area?Summary: How to filter for Finalized territories in Sales - CRM Territory Resource subject area analysis? Content (required): I'm using Sales - CRM Territory Resource su…Chin Chi-Oracle 51 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Position Vacancy ReportHello, does anyone know how I could report on vacant positions in HCM? I need to be able to report on both positions that are currently vacant, and positions that were v…User_2025-02-07-03-52-39-913 691 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Why are expenses in my OTBI report multiplied?Summary: I'm trying to build a report in OTBI that details the status of corporate card transactions. We would like to see what transactions have not been placed on an e… -
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 911 views 11 comments 2 points Most recent by ahmed alsharief Reporting and Analytics for HCM
-
How to derive Consumed Quantity ValueSummary: Requirement is to get the Review Supply Availability for a resource , I got the Table which stores the Supply quantity value, I am not getting the source table/…
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …