OTBI
Discussion List
-
Report on Activity StatusSummary: I'm attempting to prepare a learning status report to share with our managers. As we have several offerings with multiple activities, they are interested in the… -
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 31 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 285 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 21 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Getting Transaction Header DFF values in to analytics reportsSummary: Content (required): Hi All, Is it possible to get the dff values specifically the transaction header dff values in into an analytics report? Version (include th… -
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 21 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 62 views 10 comments 2 points Most recent by User_2025-02-05-19-57-56-573 Reporting and Analytics for HCM -
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes?Yasmin Kennedy 62 views 5 comments 2 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany -
GL Journals details?Summary How to build a report to get the journals details?Content Hi Experts, How to use OTBI to build a report to get the details of the GL journal? like the one below …Yasmin Kennedy 59 views 8 comments 2 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany -
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 22 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 151 views 3 comments 2 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Touch less buying SetupsSummary Touch less buying SetupsContent Hi All, Please share setups Documents for Touch less buying Setups. Thanks, Dev Thota. Version 21B -
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 22 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 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM