Global HR
Discussion List
-
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…User_VR8E0 57 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 103 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
In any of the OTBI Subject area, multiple Manager_Type are not available.Summary: When I am using workforce management checklist real time subject area for the 'Contact Person for external' type of manager I am unable to find column where the…User_2025-02-11-23-20-16-609 11 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 71 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Audit report on All approvers of the HCM transactions for previous yearSummary Can we get a report on approval history of all completed HCM transactions along with Initiator and list of approvers? So if a transaction was approver by 3 appro…Manju Nair 83 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on Guided Learning UsageContent Hello, This might be a long shot, but our business is trying to report on how often employee's are using guided learning. Are there any tables that store the usa…User_2025-01-31-00-25-12-234 26 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Position/Incumbent Report - by FTEContent I am trying to create an analysis that lists the current active positions, by department, the position FTE and all employees assigned to the position and their F…Annette M 565 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Summary How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Content Hi Experts, How to Display BIP Report Output file with Data stamp. Examp…Bala Kasineedi 83 views 6 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM
-
Not able to generate csv file which has both English and ArabicContent Hi, I am not able to generate pipeline delimited csv file which contain both English and arabic values. Arabic text is replacing with some other characters in CS…Nivya Mathire 20 views 6 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 201 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Employment History extract is not picking up Salary history records when assignment effective date iContent Employment History extract is not picking up Salary history records when assignment effective date is not between salary start date and salary end date Here are … -
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 564 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 109 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
-
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 -
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 33 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 48 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 470 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 310 views 2 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM