OTBI
Discussion List
-
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…Noelle Bartlam-Oracle 91 views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 71 views 2 comments 4 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 61 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 81 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Currency conversion in OTBIContent When using the Expenses - Expenses Transactions Real Time subject area, is it possible to get the currency conversion of an expense report to the users default/p… -
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 21 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 42 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 -
SQL Query for Territory BIP ReportSummary: Actually I trying to create a Territory Report includes the Territory Name,Parent Territory,Status , Dimension and Converge details . Can somebody helps with th…Tinu 231 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
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 91 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 61 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 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can Anyone Please help me on Mapping between two subject areasSummary: Hi Team, I'm building a report on OTBI using below subject areas in Oracle Learning Cloud: Workforce Learning - Learning Management Real Time Workforce Learning… -
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 51 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Extract Asset Reporting Data process for tasks from Assets workarea and from Scheduled ProcessesSummary: Auto Submit process "Extract Asset Reporting Data" for tasks from Assets workarea and from Scheduled Processes ESS jobs. Content (required): On following note E… -
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 31 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 99 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… -
How to identify slow moving items in Oracle fusion inventorySummary: Hi All, How to identify slow moving items in Oracle fusion inventory. Is there any report available for slow moving items ? Content (required): Version (include…Mangesh Shastri 453 views 5 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management -
Enhance Integrations of Deleted Entities Using Configured Reports -22C new featureSummary: Enhance Integrations of Deleted Entities Using Configured Reports- can you let us know based on which table in OAC,? Content (required): Enhance Integrations of…Adarsh Pai 41 views 1 comment 0 points Most recent by Shyam Lakshman-Oracle Product Master Data Management -
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 … -
BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ tableSummary: BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ table Content (required): Hi - I am looking for PVO to BICC sync table PJF_PROJECTS_ALL_B_ table. Please help. Version (… -
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…