Global HR
Discussion List
-
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe…User_2025-02-04-08-51-08-912 615 views 2 comments 0 points Most recent by User_XHDBT Reporting and Analytics for HCM -
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet…Prateek Parasar - GTUK, ACE Pro 112 views 9 comments 0 points Most recent by Shruthi Ramesh Reporting and Analytics for HCM -
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio… -
BIP Report Export Issue for Excel FormatSummary BIP Report Export Issue for Excel FormatContent Hi Experts, BI Publisher Report able to generate in PDF, where as if we try to export in to Excel, getting error … -
CR/LF values in rtf template issueSummary CR/LF values in rtf template issueContent Hello All, We developed an interface file and this file will be read by mainframe system. I am seeing a strange issue t…
-
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil_Makhiza 46 views 11 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Adding parameters to a deep linkContent Hi, Does anyone have steps or documentation of adding parameters to a deep link to go into a specific person's page/details from an OTBI report? Deep Link - http…Dishti Malhotra-Oracle 155 views 3 comments 2 points Most recent by Liran Reporting and Analytics for HCM
-
Creating report with HCM extract XML outputContent hi guys, I have created a HCM Extract and got the XML output. How can i create a eText report for the generated XML output? thanks Praveen
-
Denormalized view for workersContent Hello everyone! Do we have any inbuilt view in HCM which will provide a denormalized record per employee with basic fields like name, emplid, department, jobocde…Arathi Devi H 13 views 3 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Required User Entity (HCM Extract) for StateSummary User Entity (HCM Extract) for US StateContent Hi All, Please provide user entity details in HCM extract for pulling the details of US state. Thanks -
Need help on Logical SQL with UnionContent Hi Experts, I am trying to identify the New Hire's/ Exits and TEC changes using Logical SQL. Both parts of the sql works , but when UNION is applied it breaks. A…User_2025-01-30-00-14-06-021 109 views 3 comments 0 points Most recent by SM-Oracle Reporting and Analytics for HCM
-
Is there any possibility to create dynamic password protect for excel in Oracle HCM BI reports ?Summary Is there any possibility to create dynamic password protect for excel in Oracle HCM BI reports ?Content Hello Team, Is there any possibility to create dynamic pa… -
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…Aja Nealley 43 views 5 comments 2 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …Vibha Pandey - Oracle 49 views 4 comments 0 points Most recent by User_GIUF2 Reporting and Analytics for HCM
-
Conditional Format - a detail field to a summarized fieldContent I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compa…Annette M 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Address Audit ReportSummary Looking for a report with employee address changesContent Hi, Does anyone have a report that shows all address changes for an employee? Would want to see before …
-
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. …Mansur Khalil 89 views 7 comments 2 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Statement of EarningsSummary Subject area for creating an Analysis in OTBIContent I would like to create an analysis using much of the information from the Statement of Earnings but adding m…Annette M 17 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 602 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106 Reporting and Analytics for HCM
-
BI Publisher Bursting Real Time Notification/TriggerSummary BI Publisher Bursting Real Time Notification/TriggerContent Hi experts! I need to create and send an email notification whenever a person has enrolled or complet…Raymund Jerome 350 views 2 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Using Headcount Values in Reports and DashboardsContent I am trying to use headcount values in reports and dashboards, but the values are not lining up correctly. I know how to load the assignment work measure via HDL…Shannon Lackmeyer 38 views 2 comments 3 points Most recent by Shannon Lackmeyer Reporting and Analytics for HCM -
Require a report to show when a Primary Mailing Address is missing in the systemSummary It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing…User_2025-02-04-08-51-08-912 1.1K views 6 comments 3 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
Displaying Dashboard to Welcome ScreenContent Hello All, We have been able to successfully add the Dashboard to the Welcome screen in a Sandbox with Page Composer. What we are running into now is any user no… -
OTBI Reporting Leave Begin DateSummary Displaying actual Leave Date or the date when the employee returned to workContent Hi All, Need some help with an Analysis that I have built to show employees th…User_2025-02-04-08-51-08-912 42 views 4 comments 0 points Most recent by User_2025-02-10-19-46-17-403 Reporting and Analytics for HCM