OTBI
Discussion List
-
Performance Document Eligibility disappears in the new year/ Where to go for data related questions?Summary: Performance Document Eligibilities are disappearing in previous years. Where can we go to find reasons why the data is disappearing from reports? Content (requi… -
Getting Invalid URL Error while adding the BI report URL as embeded content in the dashboardSummary: I am trying to add the existing BI report to in the dashboard.Though i ma providing the correct BI Report URL while adding embedded content i am still getting t…minati_behera-Oracle 11 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM -
Need to compare 2 columns in an OTBI pivot tableSummary: I'm wanting to find out if this requirement is possible within OTBI. I have 2 dollar amounts 1 for each date paid. I need to compare the 2 amounts and look for … -
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f…Valerio Curzi 32 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Which is better: "Filters and Variables" vs "Results of another analysis"Summary: Are hidden dashboard prompts better than getting the results of another analysis? Content (required): When building dashboards, we occasionally have a need for …
-
OTBI usage dashboardSummary: Identifying OTBI usage for performance monitoring Content (required): Is there a seeded OTBI Usage Dashboard? Have seen below post and wondering if Oracle alrea…ZenG 33 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Employee Referral ReportSummary Looking for an employee referral report that will run on a condition that current date is 6 months after hire dateContent We have a DFF that tells us if someone …User_2025-01-28-20-43-56-568 98 views 6 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM -
OTBI Edit Column Formula for YYYYMMDDSummary: Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Manageme…User_2025-02-11-05-19-35-410 483 views 7 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
OTBI: Need to create a OTBI with 3 different compound layout and download it in excel (3 different sSummary OTBI: Need to create a OTBI with 3 different compound layout and download it in excel (3 different sheets in the excel: one tab for each compound layout)Content …User_MC37Q 97 views 9 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
No results after adding a column in subject area Workforce Management-Documents of Record Real TimeSummary: Content (required): Hi there We are trying to create OTBI report for a type of Document that we have. Actually, there are 6 specific custom made types, but when…Bobby Jourdan 48 views 16 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…Jennifer Wiggs 32 views 8 comments 0 points Most recent by Jennifer Wiggs Reporting and Analytics for HCM
-
Report of Delta for Old and New ManagersSummary: Hi, I need to create a report / analysis that would pull the results for the employees who have a new manager value. I have taken first steps by creating an ana…J_Haskell 24 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Hi, need to pull the Last Update date field by yesterdaySummary: I am building a report to automatically pull the old and new manager data by "Worker Assignment Details"."Assignment Last Update Date" which should be by yester…J_Haskell 32 views 15 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (15 June 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM between 14 April and 15 June 2015: * New Pack of Sample OTBI Dashboards and R…Julian Challenger-Oracle 273 views 5 comments 3 points Most recent by Ninja Reporting and Analytics for HCM -
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Document Of records- Headcount - Document Count inconsistent resultSummary: I am trying to create a report with employees who have updated their 2nd covid vaccine on the DOR. I am able to get the count correctly. Then I am trying to get…
-
Issues Reporting on Development Goals after a Global TransferSummary: We are facing an issue in reporting (both OTBI and BIP) where an employee adds development goals and shows on our reports as expected, but after they have a glo…Gabrielle Ungaro 31 views 6 comments 0 points Most recent by Gabrielle Ungaro Reporting and Analytics for HCM -
Filter to bring back the greatest Response Attempt NumberSummary: Content (required): We have an OTBI report using looking at employees Performance Review Rating (workforce performance - Performance Rating Real Time), for most…Joe Dorrian 22 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Non-Hired ApplicantsSummary: I need a report that lists all non-hired applicants in the past year. Content (required): Looking for a way to list all candidates that applied for open positio…Scott Conaway 24 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
End user unable to schedule OTBI reportSummary After clicking on the more button of an OTBI analysis, the 'Schedule' option is not availableContent Hi, I've had a quick look, but couldn't find anything linked…DLMorgan 52 views 10 comments 2 points Most recent by User_2025-02-05-19-57-56-573 Reporting and Analytics for HCM
-
Tax rates vs Tax codes SQL from HMRCSummary: How to query how much percentage of deduction is associated for each tax code based on HMRC definitions? in which tables this data avilable? for example for BR …ViswanathaReddyKetireddy 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly executed) Is there any way to find. ThanksMohammed Rafi 146 views 3 comments 2 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Why I am getting no results after using Workforce Management - Documents Of Record Real TimeSummary: Why I am getting no results after using Workforce Management - Documents Of Record Real Time . When I am using column Person Number and Document Type there is n…RakeshK 28 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to "decode" Notice Period UOMSummary: How do one decode Notice_Period_UOM in SQL/Query Builder Content (required): How do one decode Notice_Period_UOM in SQL, so that the output display e.g. days, m…
-
OTBI Concat FormulaSummary: Concat formula Content (required): I need to create a field in OTBI to show last name, first initial. Is there concat formula I can use to show this? Version (i…User_2025-02-06-00-25-02-334 38 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Date Parameters in Headcount AnalysesSummary: I am just starting in OTBI Development and trying to understand how I achieve the desired analytic with results based on comparative dates. Content (required): …
-
OTBI Report (Count Distinct - Accomplishments)Summary: Hello, I'm running an OTBI report. Is there a way to use count distinct in Accomplishments? Subject Area: Workforce Profiles - Person Profile Real Time But the …Hazel De Castro 340 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Having an issue while opening Analysis with HR Specialist roleSummary: I have an issue when I'm trying to open an OTBI analysis from the user account with Human Ressource Specialist role. But no issues occurred when I open it from …Evgeniya Repnina 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…Anton Rzhanov 73 views 8 comments 0 points Most recent by Anton Rzhanov Reporting and Analytics for HCM
-
How to use current system date as a prompt and bring current year value as a column in OTBISummary: Hi Team, I have a requirement to use current system date as a prompt in an OTBI and bring current year as a static value in a OTBI. Please suggest solutions. Th…