OTBI
Discussion List
-
Restricting LOV for a Line Manager Login for OTBI DashboardsSummary: We have a Line Manager and he is the from Operations department, when he opens the line manager dashboard from his account then he is eligible to see only the O…Nalsoft Pvt Ltd 81 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…Vijay Rajendran 37 views 9 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Looking for Learning Reports specified in 20A release notesSummary: NOW RESOLVED. 22/05/23 Hi, I'm looking for a set of reports that were listed on the 20A Oracle release notes (https://www.oracle.com/webfolder/technetwork/tutor…
-
Converting payroll elements from one currency to anotherSummary: Content (required): Hello experts, Do you know if now it is available in OTBI and UI the possibility to convert payroll elements from one currency to another ac…Valerio Curzi 48 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Reporting and Documents of Record Updating / UploadingHi all, Apologies if this is the wrong place to ask. We're looking to build a report within BIP that produces a letter of reference that can be saved to an employee's do…
-
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl…ShawShankk 102 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull rehire date in OTBI REPORT?Hi Team, How to pull rehire date in OTBI REPORT? ThanksSM_EP 211 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Number of columns mismatch. Expected: 6 columns. Actual: 7 columns.Summary It is happening while adding "Worker"."Person Number" on groupbyContent Hi, we are facing an error while we are adding "Worker"."Person Number" on groupby. The e…Nicola Petri 80 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can restrict the data in reports?Summary: How can restrict the data in reports? Content (required): Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have …
-
Query for Plans without Incumbents and/or candidatesSummary: Need assistance wtih querying plans that have no incumbent and/or candidates. Including Incumbent or Candidate counts appears to exclude plans that do not have … -
Report on Learning Alerts Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas or BI tables that can be used to report on the learn notifications that are sent out using the Alert Comp…Mahesh_M123 174 views 4 comments 0 points Most recent by Swaraj_Sudhagonela Reporting and Analytics for HCM
-
Workforce Goals Goals Status Overview Real Time and Workforce Goals - Goal Plan Assignments RTSummary: Hello, I'm trying to create an OTBI report that requires two subject areas (Workforce Goals Goals Status Overview Real Time and Workforce Goals - Goal Plan Assi…Hazel De Castro 52 views 8 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows HCM OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was available in …Ibrar Hussain 76 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
How cHi, I want to write a query that reCansel Karasoy 44 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM -
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…Visu 468 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do you bring back the last calendar date of the next two monthsSummary: Hi I've been asked to create a report where I list leavers in the next two months and I managed to find a report that shows leavers in the previous month to twe…
-
Calculation using a UnionSummary: Is a calculation from two results using a Union possible? Content (required): I have a report which I'm looking to show the % of active employees who have a wor…Gary Miller-39965 47 views 2 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Creating Reports and Extracts: How to map/link application front end fields to back end database tabSummary Looking for a simple way to map application pages/fields to cloud database tablesContent Good morning, I have been digging through the schema documentation while…User_2025-02-10-17-54-21-557 258 views 5 comments 1 point Most recent by Vamsi BOmmagani Reporting and Analytics for HCM -
OTBI Anaylsis to retrieve Security roles by usersHello, How can I create an OTBI Analysis to pull users along with their Security Roles or by able search the Role to see all the users using that role? Any help is appre…Gail Wilmoth 46 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI Color coding on rowsSummary: Hi Team, Can anyone please help us on achieving the below requirement in OTBI. We have the percentages on each of the Job row as shown. These percentages are th…Vishal Quadros 86 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Pass Dashboard prompt and analysis filters to drill down analysisI have a summary analysis of employee count by home state in a dashboard using a dashboard date prompt to pull as of a certain effective date. I have other filter criter…Susan Anderson 111 views 9 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
I am unable to fetch payroll details with worker and bank details in OTBI .Summary: When i take only payroll columns like payroll_id, payroll_name then i got output but when i select payroll columns with bank details or worker columns getting n…mohityagyik 26 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I edit/access a bursing SQL?Hello, We need to review/edit a bursting SQL in one of our integrations. I can see the Bursting SQL icon in the DM Properties but I don't see an opportunity to change or…Wendy G 48 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my …Cansel Karasoy 54 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?Cansel Karasoy 754 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How can I run the report when I select the required parameter field 'ALL'?Hi, I have 1 parameter that is mandatory in the report I prepared, assignment status, you can see it in the screenshot. It is true that the report should not be opened w…Cansel Karasoy 64 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Query to extract the last update date for document record fieldsSummary: Query to extract the last update date for document record fields Content (required): Hello experts, please, could you share the query to execute in order to fin…Freddy_Cerron 341 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 25 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Recruitment Requisitions in Draft Not Displayed in AnalyticSummary In OTBI Answers, when querying recruitment requisitions that are in draft in Fusion, they aren't not returned.Content Recruitment requisitions that are in draft …User_2025-02-05-17-23-19-130 42 views 5 comments 1 point Most recent by Tina T Reporting and Analytics for HCM