Reports
Discussion List
-
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 L 12 views 3 comments 0 points Most recent by Claudia Linares L 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.3K 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 27 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…
-
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 11 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 81 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 13 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 456 views 4 comments 0 points Most recent by User_0Z82M Reporting and Analytics for HCM
-
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 478 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 717 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 13 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.2K 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 24 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 22 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 17 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 11 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 …
-
Unable to bring max effective date record in a report while using an EIT flex fieldSummary: In a report with 2 subject areas, columns are not working properly. Subject Areas used: Worker Assignment Real time and Person Real time Created a report with s…Elavarasan S 11 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) …
-
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component…
-
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that…
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 2.2K views 10 comments 1 point Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
Error changing ReportsWhen trying to change the report from the custom folder, the following error appears:Matheus Vitorelli 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM