Global HR
Discussion List
-
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 122 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 31 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 63 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 461 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 112 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 -
HCM Transaction Status DashboardSummary HCM Transaction Status DashboardContent Hi Team, Do we any dashboard to monitor all HCM transactions? Thanks. Version 20B
-
OTBI - Not returning Most Current Assignment RowSummary: OTBI - returning more than just the Most Current Assignment Row. This began happening after our 21C update. Content (required): Hi, I'm creating an OTBI report … -
CUSTOM BIP NOTIFICATIONS NOT TRIGGERINGContent Hi, After adding BIP_CLIENT_REFRESH_TIME in Manage Administrator Profile Value, we are observing that many transactions aren't triggering custom BIP notification…
-
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 31 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 142 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 Reporting and Analytics for HCM
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 56 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_idSummary: Content (required): We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It…Annette M 41 views 13 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
HCM Extract schedule SQLSummary: Need SQL to get HCM Extract schedule end date Content (required): Need SQL to get HCM Extract schedule end date Version (include the version you are using, if a…