Reports
Discussion List
-
how to create Dynamic Parameter in Logical SQL in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…Dona Das-Oracle 122 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Hi Team,I want to apply Security on OTBI Dashboard using Area of ResponsibilitySummary: Hi Team,I want to apply Security on OTBI Dashboard using Area of Responsibility so that HR can see only their BU data not whole data Content (please ensure you …Nalin Jha 21 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
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 371 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 301 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 93 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 291 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 1 view 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 332 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM