Reports
Discussion List
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
How to add Analytics section to homepageWe've been trying to embed some infolets on our Oracle Cloud homepage, however it appears that most users (at least it seems that way based on Cloud Connect posts, YouTu… -
SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Burst Report By Managers and Email to Individual ManagersSummary Burst Report By Managers and Email to Individual ManagersContent Hello everyone, I have a requirement where I want to create a BI Publisher report that groups em…Daniel McMillian 477 views 9 comments 0 points Most recent by Karthick_Sathasivam Reporting and Analytics for HCM
-
Benefit:Certifications and Action Items tables informationContent Hi All, We have a requirement to fetch "Certifications" and "Action Items" tab related data in the BIP report. May I know in which tables holds this information …
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 72 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Trouble converting Double to Decimal/Numerichttps://us.v-cdn.net/6034893/uploads/9VSYBPB2KHPU/deduction-conf-layout-template.docx Summary: Attempting to create a BI report which creates a file for sending via SFTP… -
Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 31 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following … -
How should I define all parameters as multiple selection in sql report?Parameters are defined in this way in the SQL report I prepared.In this way, I can make more than one selection in the location with the parameters.But for example, when…Cansel Karasoy 41 views 12 comments 0 points Most recent by Stephan Steup - ITUP Reporting and Analytics for HCM -
Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 111 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Duplicate element entry report with entry detailsSummary: I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on …Vibha Pandey - Oracle 31 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
Dhajani Perera 1 view 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Need a Sample SQL to fetch Benefits Enrollment Data using a Batch Name from HSDLSummary: I have loaded the Benefits Enrollment using HSDL where we provide Batch Name. My requirement is that using the Batch Name as a parameter, I need to fetch the lo…Sujeeth Chinta 1K views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM -
How To Add A New Column With Custom Date FieldSummary: I have an OTBI report where I need to add a column (see expected date column below) that when there is a Termination Date it shows the Termination Date BUT when…
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM
-
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 121 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 362 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 13 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…