Reports
Discussion List
-
Custom Payslip Prints Wrong AmountsHello experts! We use a custom format for our payslips. When the payslips are generated, if an employee has money going to different banks, and one prenotes and the othe…Henry Imgrund 18 views 2 comments 0 points Most recent by Henry Imgrund Reporting and Analytics for HCM -
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 129 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
which table having the United States Job Information under the Manage Job setupSummary: Hi Team, We could not find the right table for "United States Job Information under" the "Manage Job setup" We have gone through multiple table but we are unabl…Opkey PA 15 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM
-
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…Shruti Krishnan 54 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
In which table having the Workday informationSummary: Hi, We need a table to get workday information. For the setup: Manage Department have the workday information and we could not find the right table. Attached sc…
-
How to get the last assignment if the worker have several records in a Analysis and Report (Goals)How to get the last assignment if the worker has several records in an Analysis and Report (Goals). We need to get the last assignment considering their last assignment …Claudia Linares 20 views 3 comments 0 points Most recent by Claudia Linares Reporting and Analytics for HCM -
HCM Help desk query FAQ accesses countHello Experts I need to acquire information from Help desks FAQs in HCM More precisely: * Name, info, last update, etc And the best after this would be to discover how m… -
Onboarding/Recruiting Employee Name fieldSummary: What is an alternative for updating the "Employee Name" in OTBI, where it displays First Name Last Name for Onboarding/Recruiting, and not change any of the exi…
-
How to show Attachment Link in the ReportSummary Is there a way to show actual attachments link in a report whether in analysis or BIPContent Is there a way to report on actual attachment which was attached as …Prateek Parasar - GTUK, ACE Pro 1.2K views 25 comments 3 points Most recent by Neha_Naik004 Reporting and Analytics for HCM -
Employees with and without goalsSummary: Hello, I need help on this report. I need to show employees even if no goals. It used to show properly but now the report is only fetching the "with goals" stat…
-
OTBI Report Library ReportSummary: First question: Is there a subject area besides OTBI Usage that displays the entire catalog of reports, allowing you to filter by a commonly used field? For exa…
-
Compensation - Indvidual compensation real time not showing any detailsDespite of having the necessary roles I still don't have access to show data from this subject area I added everything from this document, Document 3052888.1 but still, …Joliver Caangay 23 views 4 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
In which table has the information of Manage Legal AuthoritiesSummary: SQL query or Table has the information of Manage Legal Authorities Content (please ensure you mask any confidential information): Version (include the version y…
-
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 16 views 0 comments 0 points Started by Opkey PA Payroll and Global Payroll Interface (GPI)
-
Goals Created or Not Created by Country CodeSummary: When I use the union report suggested by Oracle/the community forum the no of workers without goals is not returning enough workers Content (please ensure you m…LTalbott2 12 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can…Reddykrishna 63 views 4 comments 1 point Most recent by Soumya Suravita Reporting and Analytics for HCM -
Employee Name ChangesSummary: Employee Name Changes Content (required): I'm trying to determine via OTBI the history of someone's name and their changes, but I don't see any values where I t…
-
OTBI missing journey tasksWhen creating an analysis to report on deferred journey tasks, I am not seeing ALL results. I am getting some, but there are definitely others that are seen in the UI, b…Jessica D 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…AvishekNandi 387 views 4 comments 0 points Most recent by User_0Z82M Reporting and Analytics for HCM
-
Competency proficiency reporting - employee and manager ratingSummary: Hi there, I need help where to find the Employee rating for Competencies. The Manager rating is located in this folder "Workforce Performance - Performance Rati…
-
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch…Aloka Bhattacharya 460 views 10 comments 1 point Most recent by Naresh Choudhary Reporting and Analytics for HCM -
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…User_2025-01-28-05-11-13-165 623 views 11 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
In which table has the information Manage Reporting EstablishmentsSummary: Hi Team, Need a table or sql query to get the information Manage Reporting Establishments as in below marked screenshot Content (please ensure you mask any conf…Opkey PA 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.1K views 2 comments 0 points Most recent by Micha---- Reporting and Analytics for HCM
-
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload…Martina Iovino-Oracle 21 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do …Parag Hiremath 16 views 3 comments 0 points Most recent by MitG-Oracle Reporting and Analytics for HCM -
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme…Marie Joyce Wynona Marzan 15 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to add field of Responsibilities under Work Experience when printing the candidate?Is there a way to add the field of Responsibilities under Work Experience when printing the candidate details?Shaina_Manalo 13 views 1 comment 0 points Most recent by Jessica Reilly-Oracle Recruiting, Opportunity Marketplace
-
organization seniority date on multiple contractsSummary: How can I report on the Org Seniority Date when person has more than 1 contract Content (please ensure you mask any confidential information): Hello Has anyone …