OTBI
Discussion List
-
How to know BI reports andOTBI Reports of scheduled report jobs and Agents list through query or anySummary: Hi Team, we have sceduled reports and OTBI reports through Agents how to get the list of reports scheduled from system any query or OTBI for ? we have report jo…AjayKumar Maddipati 74 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI promptThe OTBI prompts to exclude the Legal Employer having "DO NOT USE" word. On OTBI reports, we have applied Legal Employer Prompts, it shows all legal employers in the pic…Ashok Kumar Sharma 22 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Issue in dashboard PromptSummary: Issue in dashboard Prompt Content (required): Hi All, We have created a dashboard prompt using the Workforce Management - Worker Assignment Real Time subject ar…Venkatesan 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Annualized Salary Doubling when adding in Level 1 Organization Name in OTBI ReportSummary: We have a report built which is combining Compensation - Salary Details Real time and Compensation Individual Compensation Real Time subject areas. We have sala…JMora1234 43 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Mouseover on Performance TileDears, is it possible to change somehow the mouseover on performance title? I've been trying to add an html "title" within the cell header but that did not work. Thanks …Domenico P. 41 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Is it possible to include a link to a PDF file in an OTBI report?Summary: We are looking to have a report based on the Documents of Record subject area where the user can run the report and access the document reported as a PDF. Conte…David Bean-259734 83 views 4 comments 0 points Most recent by Greg Rank Reporting and Analytics for HCM
-
How to convert multiple rows into columnsSummary: Need help converting rows into columns for the attached report OTBI report. I tried to use Pivot and Case statement but, was still stuck. Here is the sample OTB…Ashok Kumar Sharma 62 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 23 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Creating a My Reporting tab in HCMSummary: Anyone created a My Reporting tab in HCM with links to dashboards? Content (required): I was recently on a demo using the Vision environment and spotted that a …
-
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 54 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
In OTBI Report,we are used Worker assignement Event Real time but "State" column not available ?Summary: Hi Team, In OTBI Report, we are used most of the employee address columns from ( Worker assignement Event Real time) subject area but "State" column not availab…AjayKumar Maddipati 32 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Union Query - R12 - Career StatementsSummary Report working in R11 but union no longer working in R12Content Hello I have an analysis in R11 that we use to identify the % of staff who have a career statemen…Andrew Braid 100 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Career Development ReportSummary: Trying to create an OTBI report using subject area "Workforce Career Development - Development Goal Overview Real Time". I have no issues adding fields from Dev…
-
Data Security in BIP ReportTeam, Which is the best way to apply the data security in BIP Report. Example: User belongs to the business unit "BU-A" should be able to see the data of "BU-A" We have …
-
OTBI Emergency Contact by EmployeeSummary: Dear Community, How can i produce an OTBI report to generate an emergency contact? Can anyone share sample Data Model? We need to use this for Incident Response… -
Scheduled OTBI Report to provide output as on previous dateSummary: Want to schedule OTBI report which triggers output as on previous date as effective date Content (required): When OTBI report is scheduled, we have a requiremen…
-
Drill Down OTBI bar chart report is not working correctly using several columnsSummary: We have a master report which has the following columns: -Positioning Before, Grade Code, Gender, Number of eligible employees. I used a stacked vertical bar ch…bervin13 93 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Duplicated records on OTBI Report linked to different assignments on Person dataSummary Duplicated records on OTBI Report linked to different assignments on Person dataContent Duplicated records on OTBI Report linked to different assignments on Pers… -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason…
-
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…Maciej Kozakiewicz 167 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM
-
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report …User_2025-02-04-08-51-08-912 41 views 6 comments 0 points Most recent by Roma Pandey Reporting and Analytics for HCM -
OTBI Row to Columns Conversion (FA HCM Rel 9.2)Summary Can we convert rows into columns in Fusion OTBIContent Hi Experts, Please have a look at attached word document and png file s and adviseAshishERPCloud 83 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Customer Statement Report using OTBI.Summary: I want to modify existing OTBI report for Customer Statement Report for which I have to fetch Commitment cost as Expenses under Expenditure Category. For which …Yashdeep 51 views 4 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for HCM
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to…Gal Shani 97 views 7 comments 0 points Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…Cora_Stanciu 32 views 3 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 43 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM