OTBI
Discussion List
-
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 31 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 285 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 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
-
Is there any way to pull the employees in OTBI having future hire dateSummary: Is there any way to pull the employees in OTBI having future hire date?
-
I need a query to get Payment Method , Payment Category descriptionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bahaa 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Need formula for anniversary date on 1st of month instead of day of hireSummary: I need to calculate anniversary dates so that they are the first day of the month they fall in instead of the annual hire date. I have got it partway there but …
-
How to check what all Oracle Applications modules are implemented in oracle fusionSummary: Hi Team, Is there anyway to get the details of all the modules being used in an oracle fusion instance? Either any table that stores the data related to impleme…
-
Subject Area to get real time ESS Job details for OTBI Analysis dashoboardHi, We have a requirement to create an ESS Job monitoring dashboard to show summary of ESS Jobs by status and few detail drill down reports. Is there any subject area wh…Ankit_Bhadja 12 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP -
Procurement DashboardSummary Out of Box Procurement Dashboard in Oracle Procurement CloudContent Hi Experts, I am looking for the Procurement Dashboard (out of the box (Update 20A)), have se…
-
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…Colin M 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t…
-
Parent manager 2 job tileFrom the Worker Assignment Real Time Subject Area I could get the Parent Manager 2 Name. How do I get the Parent Manager 2 Job Title ?Trupti Khodke 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to build a repot to get all action changes on the EMP recordI am using Worker Assignment Event real time subject area, to pull all the actions that happened on the employee record. When I add action and action reason I noticed th…Trupti Khodke 71 views 14 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
How do I add the last absence end date from the last 5 occurrences?Summary: I need to report on the last absence end date on the attached report. It is currently filtered by rolling last 52 weeks and number of absences measure of 5. Is …Mark Stoker 31 views 1 comment 0 points Most recent by Fechete Iustin - Support -Oracle Reporting and Analytics for HCM
-
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
OTBI Subject AreaSummary Grade Progression Subject AreaContent Hi, Is it possible to extract Progression Grade Ladder, Grade and Grade step, rates values with an OTBI report? If yes, whi…Catherine Varvaressos 77 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
In OTBI - the Position Name by Position Code is not historical - is this correct behaviour?Summary: The Position Name Field in the Position Folder in both the Compensation - Salary History Details Real Time and Workforce Management - Worker Assignment Event Re…Robert Craske 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Store signature in cloud (employee DOR or somewhere) to be used in the reportSummary: In EBS we used to be able to store the employee signature in the DOR, then we used the image in the PDF reports (like tax certification). We wanted to do the sa…