OTBI
Discussion List
-
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
What optimization is done for BICC extracts in 23A patchSummary: Optimization extraction to BICC in 23A patch. Content (required): BICC is providing EFF attribute extraction before the 23A patch itself, however, the increment…Shyledher Boddu 151 views 1 comment 2 points Most recent by Gaurav Johri-Oracle Product Master Data Management -
Learning Records Real Time in OTBI not producing any results for activity sequencing 23A use caseSummary: Learning Records Real Time Subject Area in OTBI is not producing any results when we replicate the learner progress example in the 23A weekly release notes - Or… -
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…ShawShankk 61 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Date of Birth less than 16 yearsSummary: Employees with Date of Birth less than 16 years. Content (required): I need to create a list of employees with a Date of Birth recorded that would make their ag… -
Data Table details for Affected Assets under Work Requirement.Summary: Please help in identifying the data Table for the marked content in attached image. We need to include it in a BIP report. Thank you Content (required): Forecas… -
HOW TO PASS AsOfDate TO OTBI AGENT OUTPUTSummary: We have created a OTBI report with AsOfDate prompt which is getting passed . This report will be scheduled monthly through agent. Our requirement is send the ag…Aathimoolam R 32 views 2 comments 0 points Most recent by Aathimoolam R Reporting and Analytics for HCM -
Report on specific Manager and his/her actions with employeesSummary: Content (required): Good afternoon. We have a request to identify any employees that one specific manager either Supervised (their direct supervisor), Hired (th… -
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 31 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 41 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… -
Infolets: need to extract the query of the Receipt Lines infoletsSummary: Could I extract the query under the "Receipt Lines" infolets? I need to extract the same details about the lines to be received, to be inspected and to go to Pu…Giuseppe Galluzzo 51 views 2 comments 0 points Most recent by Giuseppe Galluzzo Inventory Management -
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 104 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 212 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 72 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 … -
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Sangeetha Kumar 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
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 173 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 55 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 72 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 42 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 474 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Concur Travel Tool ReplacementSummary Travel Tool recommendation to replace ConcurContent Hi, Wondering if anyone has some relevant information. At some point, we will be looking at implementing Orac… -
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 41 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 275 views 5 comments 1 point Most recent by Vamsi BOmmagani Reporting and Analytics for HCM