OTBI
Discussion List
-
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 274 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 32 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 -
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 22 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 145 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 21 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 -
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): …Peter Downer 2 views 2 comments 0 points Most recent by Peter Downer Reporting and Analytics for HCM
-
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 343 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 72 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…
-
Remove Historical rows from TM OTBI analysisSummary Remove Historical rows from TM OTBI analysisContent Hi team, We have an OTBI analysis for listing out recent talent ratings for all the of the employees created …User_2025-02-10-15-30-45-495 32 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 72 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Reporting Knowledge Article Deep LinksSummary: Accessing Knowledge Article Deep links via OTBI Content (required): I haven't been able to find a way, or the correct Subject Area/Folder, to possibly report on…JA1 22 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Max Effective Date for Each ElementSummary: How to retrieve the max effective date for each Element. Content (required): I am trying to find the max effective date for each of the three Elements (differen…JA1 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Areas not fetching data properlySummary: "Workforce Management - Worker Assignment Real Time" subject area not fetching the data properly. Content (required): I am working in internal test instance, it…Raghavendra M 152 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…Kovi Harish Kumar 23 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Catalog for Payroll Balances Real timeSummary: Trying to create a report from Payroll Balances Real time SA to match the Balance Results values from SOE with the amount included in the report for the respect…Hem 81 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can deduction arrears be one an OTBI report.Summary: Deduction arrears on an OTBI report. Content (required): I need to write an OTBI report for deduction arrears. Is that possible? What subject area do I need to …Donna Valentine 21 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Capturing the time of activitySummary: Content (required): hi there I am running a report for a classroom course with several offerings. A few of the offerings happen in the same room on the same dat…Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Need a report that shows everyone is a Closed Life Event StatusSummary: Could someone provide me with the correct criteria that shows everyone who is in a closed Life Event Status. I am using the subject area "Benefits Enrollments R…User_2025-02-11-00-58-38-371 21 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM