OTBI
Discussion List
-
OTBI Report Issue with Candidate Inclusion and ExclusionI'm facing a challenge with the OTBI report. I'm trying to incorporate two sets of logic: Requisitions with candidates. Requisitions without candidates. However, when I …Ranjith Antony MPC 11 views 0 comments 0 points Most recent by Ranjith Antony MPC Reporting and Analytics for HCM -
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 13 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Privileges/Duty roles required to extract Absence data via OTBI AnalysisSummary: Hi Team, Could some one kindly help us on the below requested issue. We are unbale to extract Absence related data from the Subject Area: Workforce Management -…User_2025-02-07-03-03-32-616 201 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 41 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 21 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 286 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 41 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 133 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…