Global HR
Discussion List
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 42 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
How to create an advanced OTBI reportSummary: Short video describing how to create an advanced OTBI report using a calculated column and binning. Content (required): https://www.youtube.com/watch?v=YNcSgOvw…Julian Challenger-Oracle 33 views 0 comments 3 points Started by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL to calculate overall tenureSummary: Content (required): I am working on a BIP report and I would really appreciate if I get some help with the SQL to calculate the overall tenure of the employee w…Prajna Hegde 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Pull data for a specific person number when there are multiple Person numbers in the dataSummary: I am trying to pull management level for the manager's job vs the employee using OTBI report Content (required): I am using workforce assignment real time - how…Riti Malhotra 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
PERIODROLLING for Annual TurnoverPERIODROLLING for Annual Turnover I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) . …
-
DoR DDF correlation table HDOR.DEI_INFORMATION_NUMBER2Summary: Hello experts I'm trying to query some Document of records for brazil taht have fixed DDFs SELECT HDOR.DEI_INFORMATION_NUMBER2 as "STATE" HDOR.DEI_INFORMATION_N…Pedro Teixeira 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
Delegation ReportSummary: Content (required): Is there a report or a subject area in which we can report all current delegations? We want to find which people are delegating to others an…Annette M 22 views 2 comments 0 points Most recent by Wiktor Ornatowski-Oracle Reporting and Analytics for HCM -
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL or tables for Resignation Workflow Approver historySummary: Resignation Workflow Approver history Content (required): Hi all, I need to pull our the workflow details of Resignation workflow in BI. So please let me know f…Aditya Lanka 402 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 125 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to join 2 tables without common column in SQLSummary: Content (required): How to join 2 tables without common column in SQL and get the columns from both the tables side by side? I tried using the CROSS JOIN and UN…Prajna Hegde 32 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Termination Report Unable to Pull In SalariesSummary Trying to pull a historical report of terminations in a certain location with salary amount at time of termContent Hi - I have looked into a number of posts rega…Kyle Norris 64 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 464 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Turnover for a Certain PeriodSummary: Is it possible to report on period start headcount and period end headcount for anytime period instead of month start and month end from the Workforce Trend Rea…Anita 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Excel formula in BI reportSummary: Need to include excel formula like DATE and DATEIF based on hire date pulled in one column Content (required): Hi Our requirement is to calculate a date using e…Poornima Paliwal 31 views 4 comments 0 points Most recent by Poornima Paliwal Reporting and Analytics for HCM
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Getting Shift Hours For An Employee On Particular DateSummary: Folks, We have a requirement to fetch the Hours On Date. Example. Find the screenshot attached. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-…
-
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…User_2025-02-01-03-43-13-079 114 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM
-
Where do we define additional Manager detailsSummary: Hi Everyone, I am trying to find out where can we define Manager details in Assignment screen. Attaching screenshot for referencce. Content (required): Version … -
Termed employee report with both Manager hierarchy AND final salarySummary: Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND also final salary? Content (required): Has anyone written an O…User_2025-02-04-15-06-22-759 21 views 1 comment 3 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report Vacant PositionsSummary: How to report Vacant Positions. Content (required): How to identify "empty seats" on a Pooled Position and report Single Positions without incumbents Version (i…Fabian Galarza - HCM Cloud 51 views 5 comments 1 point Most recent by Fabian Galarza - HCM Cloud Reporting and Analytics for HCM
-
Need Primary Home/Mailing Address DBI.Content We need to fetch employees Primary Address and tried to find DBI but no luck. Please anyone help me.Jayakrishna Paleti 24 views 3 comments 0 points Most recent by User_7836 Reporting and Analytics for HCM -
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n… -
Need OTBI Subject Area and columns for incomplete tasks under Allocated Checklist.Summary: We have a requirement report incomplete tasks under Onboarding Checklist, I used Workforce Management - Checklist Realtime subject area. I am able to get the ch…Raghavendra M 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extract Termination Notification details which are still under approvalSummary: I am trying to create a query to extract Termination Notifications, which are still under approval. Following is the query that I prepared. But it's ending into…Dharmendra Shukla 51 views 7 comments 0 points Most recent by Akhil M Reporting and Analytics for HCM -
i'm not able to read finance data related to over time and training expence in custom HR dashboardSummary: Hi i used finance subject area (General ledger-Transactional balance real time) in HR dashboard but system is not allow to me to select subject area , i think t…Mahgoub S.Mohamed 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query for extract Hierarchy ManagerHi there , we need to reconstruct the hierarchy of a user's managers via a query in BI. The real problem we encounter when a manager then has several active assignments …User_2025-02-07-06-30-13-200 2K views 6 comments 0 points Most recent by User_2025-02-07-06-30-13-200 Reporting and Analytics for HCM
-
Delete Fusion Report Job Which is scheduled in Other AccountSummary: Delete Fusion Report Job Which is scheduled in Other Account Content (required): We have requirement to delete the report job which is scheduled in other user a…Vasanthakumar Ravi 41 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Can you tie Worker Assignment Event Real Time to the HCM Approval Notification area?Summary: We have a request to pull all terminations during a defined time period for a certain Business Unit and then show when the termination transaction was initiated…Cheryl Burwell 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM