OTBI
Discussion List
-
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex… -
Navigation to ERP AnalyticsSummary: Hi All We have client that buy ERP Analytics license. How to navigate to this ERP Analytics? You can check the screenshot using this link : https://www.oracle.c…
-
Customize/remove action button in infolets for fusion HCMSummary Customize/remove action button in infolets for fusion HCMContent We have a requirement where action button of infolets needs to be hidden for users. Please share…
-
Logical SQL: How to Calculate Response PercentageHi Community, I have BU, ResponseCount and BUTotalCount columns in my Logical SQL based report. Response Count: It is number of responses from employees on a questionnai…Ashok Kumar Sharma 11 views 6 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
OTBI PO Balance Report to Tie to Budgetary Control Obligation BalancesSummary: I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We …Ashley Dore 21 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for ERP -
customer required a report to fetch resources dataHi Everyone, we have a requirement to create a report to fetch details of resources who are working in a project for more than 24 months for a client. Can anyone share t… -
Embed a Link on the Dashboard to take to Submit a Flow page in HCMSummary: Like Deep Links/Action Links, can we have a LINK on the OTBI analysis/dashboard to let the User submit an HCM extract via the Submit a flow page. Content (pleas…Vibha Pandey - Oracle 11 views 2 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to …Oriana L. 21 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Reporting on future dated positions using OTBI 'Position Real Time' subject AreaSummary: Is it possible to report on future dated positions using the 'Position Real Time' subject Area in OTBI? Content (required): I current report on all active posit…Paul Morrissey 51 views 4 comments 1 point Most recent by Paul Morrissey Reporting and Analytics for HCM
-
Formula for "Begins with"Summary: How to write a Formula that says If Department Begins with 3 THEN "Division1" I know how to write the standard formula using CASE(IF) but not sure what function…THawkins_LGI 11 views 4 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Restrict Diversity fields from Person Real Time Subject AreaSummary: Subject Area - Workforce Management - Person Real Time Folder - Person Legislative Information Fields - Gender Identity, Sexual Orientation User should have acc…Bindu Vasa 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fact Definitions - Candidate Tracking Real TimeSummary: Content (required): Where can I find the definitions of facts in the Candidate Tracking Real Time Subject Area? I'm looking for the difference between 'Number o…Susan Anderson 102 views 11 comments 0 points Most recent by User_MN692 Reporting and Analytics for HCM -
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
Legends not appearing correctly in graph viewHi, I have to create a graph where I have to show voluntary termination and total termination in one graph(region wise). I have created the graph but in the legend it is…Parul007 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Changes L-SQL Query IssueHi all, I've been using and adapting Julian's L-SQL query posted here: to try and return previous roles for employees. It all works great until we have someone who has t…MikeW 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
open PO report with receipt datesSummary: We are trying to build a report with open POs and their associated receipts. Content (please ensure you mask any confidential information): Requirements are ori… -
Employee / Line Manager / HR Specialist seeded analyticsSummary: Customer want to know any seeded list of Employee / Line Manager / HR Specialist analytics or dashboard Content (please ensure you mask any confidential informa…Suresh Manoj Kumar-Oracle 21 views 5 comments 0 points Most recent by Suresh Manoj Kumar-Oracle Reporting and Analytics for HCM -
Show all employees whether they have been on a course or not.Summary: I am trying to gauge an approach to producing a list of employees with the courses that they have completed/in progress etc. using the subject areas for "Workfo… -
Delivered reports are available only in english?Summary: Hello, I would like to know if the delivered reports are available only in the english language. Thank you. Content (please ensure you mask any confidential inf…
-
Helpdesk Requests that have Journeys assigned to them on an OTBI**This post was created as part of a How to Service Request (SR) Release: [Version] 11.13.24.04.0 Summary of the question: Can we identify Helpdesk Requests that have Jo…Bodhisattwa Mukherjee-Oracle 2 views 2 comments 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
OTBI reports using cross of different subject areasSummary: Hi All, Is it possible to build OTBI reports using cross of different subject areas? For example: For Fixed assets, we have two subject areas: Fixed Assets- Ass… -
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…ramesh.sivapalan 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
EIT Field value is not displaying in OTBI-AnalysisContent Hello Community, We have created an Analysis in OTBI, with simple fields from the "Workforce Management - Worker Assignment Real Time" subject area, which work v…User_2025-02-05-16-57-43-236 35 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Is there a standard report for Work ConfirmationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
OTBI icon with starSummary: Regards Oriana Content (please ensure you mask any confidential information): Hello experts, does anyone know what this icon refer to? I basically have an otbi …Oriana L. 21 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
enable password to custom OTBI Text FileSummary: Dear, Customer request to enable in custom Report password security, as following User Run the Custom Text File Report User Download the File to Open that file …Mostafa Yassin 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP