OTBI
Discussion List
-
Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…Nishit Doshi 11 views 1 comment 0 points Most recent by Sunder Subramanyan-Support-Oracle Reporting and Analytics for HCM -
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 107 views 15 comments 6 points Most recent by Radouane Allam Reporting and Analytics for HCM -
Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav… -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 134 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 54 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 11 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
OTBI Performance Management Summary dashboardSummary: Need path for this seeded report dashboard Content (please ensure you mask any confidential information): Our customer has this screenshot showed and mentioned …Rajkumar Subbareddi 65 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Scheduled OTBI reports- What happens when person who scheduled reports gets terminatedMy team has been scheduling reports for end users using their IDs (instead of a generic/master account). I was wondering what happens to the scheduler agents when the pe… -
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge…
-
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 139 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM
-
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
Generate candidate list for incomplete submissionsSummary: how do i generate a list of candidates that did not complete their application? Content (required): Hi we are in process of migrating from Taleo to ORC 22A and …MarkHodges 43 views 3 comments 0 points Most recent by Harika.Viswanatham Reporting and Analytics for HCM -
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 12 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 13 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Approval Date of the Approved Absence in Workforce Management - Absence Real TimeI'm currently creating a dashboard for Absence Management. Why there are Approved Absence, but the Approval Date is Null?Welsey 11 views 2 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for HCM -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Termination ReportSummary: We are new to Oracle and looking to build a simple termination report that returns all terminated workers. Current problem we have is that it's returning termin…Darrin N 257 views 14 comments 0 points Most recent by Manmohan Mohapatra-Oracle Reporting and Analytics for HCM
-
How to enter a Column Group in a OTBI reportSummary: How to enter a Column Group in a OTBI report Content (please ensure you mask any confidential information): Hi, we would like to create a new OTBI report, which…Barile Alberto 153 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SCROM ReportSummary: Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. We are trying to create a report to take out the …Teja Arepalle 31 views 2 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
Element Entries Real Time - Retroactive Payement DateSummary Within Element Entries Real Time - I have Retroactive payements made to employees however in OTBI i cannot locate 'Orginal Date Earned'Content Overview: For Empl…User_2025-02-04-23-40-44-792 53 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w…G. Class-Peters 21 views 6 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…User_2025-02-12-02-03-48-970 41 views 9 comments 0 points Most recent by User_ZKDAR Reporting and Analytics for HCM
-
Logic to know the Insert/Update/Delete as Audit Action in Audit Salary Report for HCMWe want to build an HCM audit report in OTBI. HRDirect needs an audit report to see when a salary change was added, updated or removed an individual. Filters: Employee I…Mukesh Bulla 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI excluding the requisitions that are in any other phase other than "Open"I am creating a report using "Recruiting Real Time". The report works fine when i run with the basic attributes like Requisition number, name etc. But as soon as i inclu…Girish Bhatia 13 views 5 comments 1 point Most recent by Alice Gouzy Reporting and Analytics for HCM -
Compensation Business Process Dashboard Access ControlSummary: Business requirment is to restrict access to the seeded Compensation Business Process Dashboard for Line Managers. Identified that Workforce Transaction Analysi…SaiGayatri Chevooru 31 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Role for OTBI reportSummary: Role for OTBI report Content (please ensure you mask any confidential information): Hello experts, we have created a custom role (BI-Abstract) that allows users…Oriana L. 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 61 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
what is the BICC VO for Position EFF?Summary: I am trying to find the PVO for extracting Position EFF data and it is not available in the datastores. I could find the Assignment and Job EFF but not Position…Veena Pindiganti 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management