OTBI
Discussion List
-
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB…Oriana L. 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Restrict parameter value in seeded line manager dashboardSummary: We are using Line Manager Dashboard in Fusion hcm, we have different BUs and we have requirement to restrict business unit & legal employer parameters (LOV) in … -
How to report Open Requisitions with AS OF DATE parameterSummary: Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022. Content (required): I have an…
-
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c…Crystal Pace 44 views 4 comments 0 points Most recent by Crystal Pace Reporting and Analytics for HCM
-
Which table Stores the AP Invoice Mail Received Date by the IDR and Process Date by the IDR?Summary: I'm creating a custom report and I need to add the Dates when Mail Received by the IDR and Process by the IDR. I refer from the OOTB report (IDRImageTraceabilit…James Canaber 41 views 2 comments 1 point Most recent by Brian Burns Payables, Payments & Cash Management
-
OTBI does not display and filter standard Oracle Cx attributesSummary: Hello community, I hope you are well. To generate a Leads report, you need to filter the Leads by type of currency, the standard attribute of "Revenue". "Curren…XUM TECHNOLOGIES 31 views 2 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales -
OTBI Subject Area permissionsSummary: I have an issue attempting to edit reports in Oracle Transactional Business Intelligence (OTBI). Specifically, when trying to edit reports related to different …XUM TECHNOLOGIES 21 views 3 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
How to edit contents within a Data Model Report?Summary: Need to update our disclosure form that is a data model thru OTBI connected to Our New Hire Journeys. Is it possible to upload the new data model or edit the co…
-
'Signer Address' column in Checklist Real Time Subject AreaSummary 'Signer Address' column in Checklist Real Time Subject AreaContent We are trying to leverage Checklist Real Time subject area to develop reports on the onboardin…User_2025-03-07-21-34-36-848 43 views 5 comments 1 point Most recent by Marcy Hart Reporting and Analytics for HCM
-
Join Validated Date to Invoice Details in OTBI Data ModelSummary: We are trying to write a query in OTBI to create a data model that joins Validated Date and Validated By to Invoice Details. In running the query below, we noti…hannah_barry 23 views 3 comments 0 points Most recent by hannah_barry Payables, Payments & Cash Management
-
Report to show when a spouse works for the same companySummary Benefits for spouses that work for the same companyContent Hi All, I am hoping someone can help me out. We have a request to generate a report that shows when th…User_2025-02-04-08-51-08-912 69 views 10 comments 0 points Most recent by MarleneRay Reporting and Analytics for HCM -
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
How to filter out duplicate value for multi-rows attributes in OTBI analysisSummary: The OTBI analysis shows duplicate value for multi-rows attributes. I need a way to filter them out in analysis. Content (required): I have two multi-rows attrib…
-
Report on who edited an assignment and the commentsSummary: I need to have a report that shows who modified/edited an assignment and the Notes, Comments, Justifications (anywhere, that someone need to put in the reason w…
-
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s…User_1VTMP 33 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of…
-
Beneficiary missing some dataSummary: Hello! I am using subject area Benefits - Enrollment Real Time to pull out primary beneficiaries. I have a record in file that is missing some data. EMP Person …Sarah D 41 views 5 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Busting OTBI Myths - Reporting on future or past dated informationContent Myth: You can't report on future dated or past dated information in OTBI Data is generally as of the current date. You can define the report effective date to th…Julian Challenger-Oracle 275 views 16 comments 5 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
asset by locationSummary: Fixed Asset report with financial and location details Content (please ensure you mask any confidential information): For State/Corporate Income Tax reporting r…
-
OTBI reports new calculated item based on the result of a previous created calculated item?In OTBI reports is it possible to create a new calculated item based on the result of a previous created calculated item?Thomas Machado-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Trading Partner Web Service: REST or SOAPSummary: Need url for creating Manufacturer type trading partners Content (please ensure you mask any confidential information): Hi All, Please share url of SOAP or REST…MohitChandane 42 views 3 comments 0 points Most recent by Krishna -Oracle Product Master Data Management
-
Is there a way we can get the Approved by person in Definition step of NIR using OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 131 views 6 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Documenting the Technical part of Dashboard customizationSummary: Hello, We utilized the Oracle cloud prebuilt dashboards, added custom formulas, new attributes, groups and documented the technical part of custom changes with …
-
Lead Times reportSummary: Is there a standard cloud report that shows the lead time per supplier? It doesn't need to be by item and supplier; it can be something like the average lead ti…
-
does Minimum Price in course creation is available in OTBI ReportSummary: Does Minimum Price in course creation is available in OTBI Report Content (please ensure you mask any confidential information): Version (include the version yo…
-
Do we have Out of the box OTBI report specifically for Production Scheduling?Summary: We need details on the standard Out of the box reports for Production scheduling, any lead would be highly helpful. Content (please ensure you mask any confiden…Vatsala Bharadwaj-Oracle 11 views 1 comment 0 points Most recent by Prateek_16-Oracle Reporting and Analytics for SCM -
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…Madushan Fernando 43 views 1 comment 0 points Most recent by Madushan Fernando Reporting & Analytics for Fusion Service