Reports
Discussion List
-
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …Helen Thomas 23 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM -
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…Sushant95-Oracle 11 views 2 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
Embedded Grid Size and Formatting Issues in PDF Report PackagesIn our PDF report package, we insert management reports as reference doclets to embed their grids into well-formatted Word documents. The report is configured to 'fit bo…
-
Query for Project Management (PPM) relatedSummary: I need to include budget details ( labor, materials and expense), forecast details ( labor, materials, expense) and forecast ( labor, budget, expense) in my BIP…
-
Multiple Burst DefinitionsSummary: Content (please ensure you mask any confidential information): I have 20-30 books that I would like to send via email through bursting. Currently, I have a burs… -
How can I set the default of a date parameter to the same date in the prior year in Bi Publisher?Summary: Due to leap year, {$SYSDATE()-365$} is no longer working correctly to set the default for a date parameter to the same date in the previous year. Content (pleas…BeachDreamer 281 views 4 comments 1 point Most recent by BeachDreamer Reporting and Analytics for HCM -
Candidate is incorrectly transferred to HR moved to previous phaseWe have an HR report under tools>reports and analytics report name: New Hire and Pending Starts Report - ExternalsNew Hire This report calculates candidates that have be…CharleyT 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…Tom John Bontoyan 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
is there an easy way to extract all the data from a specific table?Summary: Sorry in advance if this has been asked but I have not been able to find a resource to help me. I am looking for an easy way to extract all the data from a spec… -
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 138 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
OTBI Reports CalculationSummary: Hello, We have resource assignment report and our aim is to join Project Resource Assignment and Worker Assignment, in order to calculate each employee ‘s proje… -
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
Diversity Report - multiple linesSummary How to report on the latest entry?Content Hi, The report attached works for me apart from 8 employees that are appearing with multiple lines of data. I've spoken…User_2025-02-05-22-44-35-842 125 views 28 comments 1 point Most recent by Cindy Hager Reporting and Analytics for HCM -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
BIP report with Excel template output file showing wrong time when compared the value in Data modelHi Al, I am working on a conversion BIP report where I am printing Start Time, End Time in the output file. when I loaded the XML and inserted the fields into the Excel …JP Chandran 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor…Cansel Karasoy 311 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIAEm-Jay 21 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How we can schedule report to a shared folder.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Abhishek.Sachdeva 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Randomization of employee list(from different BU/Department) for every runSummary: Report to fetch Random list employees for every run Content (please ensure you mask any confidential information): I need the report to fetch randomized list of…Raksha Govindaraj 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
HR Dashboard - Headcount Tab - Where to find data, how to change colors, and how to change filters?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know the reason the colors are different for the same categories and if they can be…Jay_Brannan 2 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
Custom BI Publisher reports takes a long time to completeSummary: I created a custom BI Report. When I run the report it takes about 23 seconds to complete. When my client runs the report it takes almost 10 minutes to complete…Consultant Ian 75 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
BIP Report Citibank PaycheckHello everyone, I would like to ask if you have or if there are any existing RTFs that follow the specifications for Citibank Paycheck. Thank you.CAMIL_Q 1 view 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM