Reports
Discussion List
-
Query to get the list of roles in applicationSummary Query to get the list of roles in applicationContent Hi Experts, Is there any seeded query or custom query available to pull the list of all seeded and custom ro…Charan Kollipara 1.8K views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Time Zone in OTBI is not in sync with timezone set in user preferencesSummary: Time zone in OTBI/BI Publisher is not in sync with the time zone set in user preferences 1) How to find out all the users who have this mismatch? 2) How to sync…Keval_Shah 376 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
auditing for document of records viewwe have a requirement to get auditing report for who are viewing the document of records. we are trying to get it from OTBI but data is not coming from those columns. ca…Dara Nagasai 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Add fonts for career siteSummary: Content (required): Hi everyone, we are customizing the career site made available by ORACLE for the ORC module. In particular, we need to integrate a new font …Gerardo Peluso 302 views 3 comments 0 points Most recent by Michael Schweizer Recruiting, Opportunity Marketplace
-
Subject area or tables we can find the status history in its different phases of a candidate.Hello. In which subject area or in which tables we can find the status history in its different phases of a candidate who has not been hired as an employee. Thanks and r…Rodrigo Durán 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Comparing current Job Titles to previous week Job Titles in OTBISummary: Hi, I've been tasked to compare current Job Titles to Job Titles in the previous week. Can anyone assist in explaining how this can be done via an OTBI reports …GJ79 91 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit Report BI Publisher does not show folder informationHello! I would need some help with Audit Report from BI Publisher. It is assumed that it is not showing the information of all the operations performed at the folder lev…
-
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 21 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 300 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 2 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 342 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 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM