Global HR
Discussion List
-
Emergency Contact and Employment Info ReportSummary: Hi all. I've reviewed the documentation shared in other posts, but I'm still not getting there, for some reason (likely user error!). I need to create a report …Jessica D 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Matrix Manager - Why does OTBI return multiple matrix managers for each employeeSummary: We use Line Manager and Compensation Manager when creating or updating an employee assignment. Our reports should return no more than two managers for the curre…Michael Grant 164 views 6 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM -
OTBI analytic: Populate a value in a column based on another columnHi ! In my OTBI analysis I want to have column formula where I check if an employee have any value in column A. If a value in present in column A for an emoloyee, I want…Ida-OC 697 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …
-
Workforce Management - Worker Assignment Real Time andSummary: Hi, I'm currently working on 'Workforce Management - Worker Assignment Real Time' and it gives me 'No Results The specified criteria didn't result in any data' …
-
Employee Missing PPM detailsSummary: Hi everyone, I need a query for those employees whose bank details are missing(PPM), If anyone has this query. Please share with me. Thank you.Saher 15 views 3 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM
-
LISTAGG Function Not workingSummary: Hi Team, Please help me debugging or optimize the below query. Content (required): The result: The result I want: Version (include the version you are using, if…Robinson Ng 40 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
how to call value set in fast formulaSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
eText RTF error on Open "XML-20211: (Fatal Error) '--' is not allowed in comments."Summary: Hello I've attached my eText RTF template (in Docx extension per forum rules) and XML (as .txt) I have gone over the template and my Data Model SQL data sets bu… -
Report parameter definitionHi, There is a absence start and end date in the absence used report I created.and when i select start and end dates i want to see absences in that range this is how i d…Cansel Karasoy 27 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Duplicate Reports sent out by SchedulerSummary: Hi all. A few of the schedulers I have set up are suddenly sending out anywhere from 2-4 reports. This seems to only be happening since our 23C install, at leas…Jessica D 26 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Department EFFHi, From which table can I find the EFF field defined on the department? If you know, can you share? Regards,Cansel Karasoy 68 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Some of employees not showing checklist task name of 30days HR questionarieSummary: Hi Team, we have onboading perosn task list but some of employees have not showing even task name also and task status also. any one assist me on ? that issue s…AjayKumar Maddipati 26 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with …
-
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 18 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Report unable to generate employment information prior to 2020Summary: We have an employee department dashboard which majority of our users run on a daily basis. This dashboard has prompts to support the kind of data that the user …
-
Cost Center Data not pulling in Workforce ManagementSummary: Content (required): Our reporting team have been trying to add Cost Center to numerous reports and as yet have had no luck. This current report attached, is loo… -
Data PurgeSummary: Hi Team, Could we get the list of dependent components which will be purged when we select particular object in "Data Purge" Example: if Payroll is selected in …
-
Is there a table to find the size of files uploaded on Documents of Records?Summary: Is there a table to find the size of files uploaded on Documents of Records? Content (required): Version (include the version you are using, if applicable): Cod…PrafullMadhur 37 views 2 comments 0 points Most recent by PrafullMadhur Reporting and Analytics for HCM
-
OTBI report to pull out Position/Department Historical data with effective dates.Content Hello All, I have a requirement to pull out all the data related to Position/Department from the day of creation. I have tried to pull out the data using the sub…User_2025-01-25-06-20-12-259 216 views 7 comments 0 points Most recent by SravanthiCh Reporting and Analytics for HCM -
We have onboarding 30days questionarie BI report, issue is not showing status in reportSummary: Hi Team, We have onboarding 30days questionarie BI report, issue is not showing status in report some of employess empty coming. I observed that employess statu…AjayKumar Maddipati 36 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
After Global transfer the existing Contract Info under Employment Info is not displaying in the OTBISummary: After Global transfer the existing Contract Info under Employment Info is not displaying in the OTBI report Content (required): After Global transfer the existi…PavanBheema-Oracle 19 views 1 comment 0 points Most recent by Girish Singh-Oracle Reporting and Analytics for HCM -
Getting the value of Enable Position Synchronization field from Legal employer setupSummary: Getting the value of Enable Position Synchronization field from Legal employer setup Content (required): Hi Team, Greetings! Is there a report or diagnostic or …Parag Hiremath 26 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
What audit reports are available for HCM configuration?Summary: We would like to know the types of audit reports available for HCM modules (ORC, Core HR, Compensation, and Talent) that are configuration and not employee leve…
-
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr…Jithin Mathews 23 views 4 comments 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
OTBI : Line Managers not retrieved in Workforce Management - Workforce Trend Real Time Subject AreaSummary: We are creating a dashboard which shows attrition rate based on different aspects like country, departments, etc. We were fetching the query from OTBI analysis …Rohankumar Patel 48 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not able to extract the 'Overtime Status' - Exempt or Non-exempt from systemSummary: This is regarding HCM Job legislative info not reflecting in the backend tables in Dev7 (also noticed in Test instance). While working on a requirement that nee…
-
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 46 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Creating a Report in OTBI for New Hires, Name changes, LOAs, and TerminationsSummary: Hello, I need to create a report in OTBI for New Hires, Name changes, LOAs, and Terminations but I am unsure if this can all be on one report or if I would need…Latia 83 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM