Global HR
Discussion List
-
Use session variable to show only Health and Safety incidents for the user logged inSummary Recording demonstrates steps to get display name of user logged in and pass as a sub report to query incidents for user logged in.Content Overview of steps: * Cr…Stephanie Golly-Oracle 102 views 4 comments 7 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Report to extract approval rules configuration for HCM from FusionSummary Report to extract approval rules configuration for HCM from FusionContent Hi Team, I am looking for an option to extract the approval rules configured for HCM in…MandeepKGupta 531 views 1 comment 3 points Most recent by MandeepKGupta Reporting and Analytics for HCM -
Default Package creaation for Event Trigger usageSummary Default Package creaation for Event Trigger usageContent Hi Experts, We have a requirement where we want to restrict a report access only a specific country empl…User_2025-02-06-09-41-56-955 53 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Looking for Position ReportSummary Would like number of unfilled positions, organization chartsContent Hi everyone - we are underway with preparing to implement Position Management. We currently u…Ashley Cossey 95 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Prompt: User Selects Operator "Between"Summary If you allow users to select the operator for a date prompt, the value "between" is not available.Content We have a requirement to allow end users to select the … -
No data in Human Capital Management - Approval Notification Real Time after Sep-2019Summary No data in Human Capital Management - Approval Notification Real Time after Sep-2019Content Hello I am trying to write a report to show the approval date for sic…Helen Thomas 34 views 13 comments 2 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 140 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Deriving column value based in ROLE.Summary Deriving column value based in ROLE.Content Hi All, Need HELP I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field …User_2025-02-07-19-03-14-525 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…User_MC37Q 153 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
In process Termination ReportContent Has anyone developed a report that shows terminations in process and who it is currently pending approval with? Ideally we'd like a report that includes date/tim…User_2025-01-28-07-43-27-066 43 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we hide Factory delivered folders from Reports and Analytics based on role?Summary We have a requirement to hide all the factory delivered folders except Human Capital Management from Reports and Analytics.Content Requirement is : When login as…Karishma Dhapola 99 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Rel 20B (11.13.20.04.0)-> No data for Pending Workers in 'Workforce Management - Checklist Real TimeContent HCM OTBI Prod Dev Team, Can anyone please confirm if the issue documented in Doc ID 2600452.1 (https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-…SantoshKumarBhairi 41 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Duplicate Rows on DM/ReportContent Hi all - We want to build one data model and then use that to build multiple reports. This will help us ensure that if we update the code, we are updating all of…Prudence K 55 views 7 comments 0 points Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…Kalyan Amaravathi 248 views 14 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue …SantoshKumarBhairi 56 views 19 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Changed username and now user cannot login to OTBISummary Changed username and now user cannot login to OTBIContent Hello, We had to change the username for an existing user and now the user is unable to login to OTBI. …User_2025-02-04-15-06-22-759 157 views 8 comments 2 points Most recent by Robert Fighiroae-Oracle Reporting and Analytics for HCM
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…CB Trett 89 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
Employees Hired in the Last 7 DaysContent Hi Guys, I'm trying to generate a report to show employees who were hired in the last 7 days. I've created a Data model and basically inserted this statement int…Ivy__Valverde 145 views 12 comments 2 points Most recent by Christian_Kaladjian-Oracle Reporting and Analytics for HCM -
Action Link on Performance TileSummary Opening detailed report (attached via action link) in separate tabContent Hi All, We are compiling a dashboard which has multiple performance tiles in one sectio…Ankush Rode 59 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Original Hire Date and Grade ReportContent Hi, I am looking to report on original hire date, grade and time in a grade. Could anybody please help on this? Thank you!MohammadAfghanul Khair 46 views 5 comments 2 points Most recent by Jessie Jones Reporting and Analytics for HCM
-
Updating Existing GeographiesContent Hi, Would like to know if it's possible to insert a value to existing geographies? Like I want to add a code for a county?SunnyJaiswal 39 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Set default parameter for date to SYSDATE in BIP Data ModelContent Hello I have a date parameter in my BI Publisher Data Model, and I would like to set it by defaut to today's date. I tried using CURRENT_DATE and SYSDATE but it …
-
Get legal entities addresses in a BI Publisher Data ModelContent Hello, I am creating letters templates based on a BI Publisher Data Model. Inside these letters I need to put the address of the employee's legal entity. Is it p…
-
Area of Responsibility - Work Contacts - Table NameSummary Area of Responsibility - Work Contacts - Table NameContent Where the work contacts (Area of Responsibility) are stored in the database. If you know they are stor…SAKTHI SUNDAR 45 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Previous and Current values for a shift, crew, rotation beginsSummary Due to Covid-19 we have had to introduce new shifts for our job sites. Need to report both current and previous values for auditingContent I have been tasked wit…User_2025-02-04-08-51-08-912 37 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get the last incumbent date for vacant positionsSummary Trying to get details on vacant positions as to when it was last filledContent Looking to get whether the position ever had an incumbent and if so what the last …Mario B 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to count number of Management layers between an incumbent and the top of the organizationContent Looking to find a way to count all the management layers between employees in an organization. Have been able to do a span of control report but need to count ho…Mario B 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…James Hoffmann 117 views 22 comments 1 point Most recent by James Hoffmann Reporting and Analytics for HCM
-
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 649 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
SQL query time out error in BI ReportsSummary Getting SQL query time out error in BI ReportsContent Hi Experts, We are getting SQL query time out error in BI Reports. have made changes Query Time out to 1000…User_2025-02-06-19-27-47-357 106 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM