Global HR
Discussion List
-
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti…
-
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…User_2025-02-04-08-51-08-912 56 views 1 comment 1 point Most recent by Srdjan Ostojic Reporting and Analytics for HCM
-
Infolet Visibility IssueSummary Can we use Assignment's Descriptive field value in Infolet EL expressionContent Hi, We need to set the Infolet Visibility based on Assignment's Descriptive field…
-
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…Bala Kasineedi 516 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Delegated Roles TableSummary Delegated Roles TableContent Hi All, Is there any other table which stores delegated roles details? I am able to find the table PER_DELEGATED_ROLES but this repo…nitin Sharma 12 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…Balaganapathi Kasineedi 67 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …Mayi218-Oracle 74 views 1 comment 2 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with…Andrew_Schmitz 41 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
General Preferences OTBI Subject AreaContent Hello All. I am trying to include Language from General Preferences in an OTBI report, but I am not able to figure out which subject area general preferences are…Antoine Richard 47 views 2 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report to fetch Open Notifications for the employeeSummary Report to fetch Open Notifications for the employeeContent Hi Guys, I have a requirement to send all the open notifications as a summary via email every week to …Vinod SM Gowda 46 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Nationality Head Count AnalysisSummary Nationality Head Count AnalysisContent Hi All, May I know if anybody has done head count analysis based on Nationality . Could you please guide me. If I take fro…User_2025-02-06-09-41-56-955 35 views 4 comments 0 points Most recent by User_2025-02-06-09-41-56-955 Reporting and Analytics for HCM
-
Oracle Employee auditing that captures changes to a persons recordContent We currently have been looking at the history tab within person management and have realized that it does not give us much information. After connecting with Ora…User_2025-02-05-16-39-03-485 24 views 1 comment 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a …User_2025-01-28-08-47-04-905 399 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI layout performance tile how can i make the square border thicker?Summary OTBI layout performance tile how can i make the square border thicker?Content Hello We have an OTBI with layout of a sum displayed in a ‘performance tile ‘. The …Revital Mefano 35 views 4 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM
-
OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics, 23 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics session to have them answered during the live event. Post you…mauricio -Oracle 33 views 0 comments 1 point Most recent by mauricio -Oracle Reporting and Analytics for HCM
-
OTBI how to round up a number with decimal points to be without the points?Summary OTBI how to round up a number with decimal points to be without the points?Content Hello, In OTBI report, there is a field based on sum of FTE , which may includ…Revital Mefano 468 views 10 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM
-
HEX values for seeded pie chart colorsSummary HEX values for seeded pie chart colorsContent I have built a pie chart for Performance ratings for a Dashboard. The systems default to 3 colors - Yellow, Blue an…User_2025-02-10-08-27-16-805 20 views 2 comments 2 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
OTBI layout tile how can we replace the performance tile in the middle of the dashboard?Summary OTBI layout tile how can we replace the performance tile in the middle of the dashboard?Content Hello , We have an OTBI with layout of a sun displayed in a ‘perf…Revital Mefano 29 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
HR Help Desk Affected PartyContent Hi all, We are currently rolling out the affected party field in HR Helpdesk and I'm having issues with finding the field in OTBI. Has anyone successfully report…User_2025-01-31-00-25-12-234 64 views 3 comments 1 point Most recent by Josh Vincent Reporting and Analytics for HCM
-
Primary Ethnicity is not the only one returnedSummary In Workforce Management - Worker Assignment Real Time, there is a "Person Ethnicity" in the Worker Folder.Content When we include this field in an Analysis, the …Aaron Hager Associated Bank 59 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM
-
View Headcount by Selected LeaderContent Hello everyone, I created a dashboard for HR business partners covering basic worker and person assignment information e.g. headcount, gender breakout. I would l…User_2025-02-11-03-07-51-707 41 views 4 comments 1 point Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM
-
Disappearing images in OTBI DashboardSummary Disappearing images in OTBI DashboardContent I built a dashboard for users to look up Jobs and print out the corresponding Job Profile in a PDF format I am using…User_2025-01-23-21-24-21-434 30 views 2 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM
-
How to Report available working hours of all Employees in a department excluding Absence HoursSummary OTBI Report for Available Working Hours of All Employees using either FTE or Normal Working Hours from Employee Assignment by excluding the Absence Hours during …
-
Custom Columns with field from different Subject AreasContent Hello, I am working on a report that has 2 subject areas (SA). I am trying to include a column with a formula (CASE WHEN statement) using fields from the 2 subje…User_2025-02-05-06-26-19-951 57 views 5 comments 1 point Most recent by user5070067 Reporting and Analytics for HCM
-
EEO1 Electronic Establishment ReportSummary Unable to find the EEO1 Extract flow name to submit by Navigating through Data Exchange--> Submit Extract.Content Unable to find the EEO1 Extract flow name to su…User_2025-02-06-23-16-04-175 19 views 2 comments 2 points Most recent by User_2025-02-06-23-16-04-175 Reporting and Analytics for HCM
-
Analysis failing with error: Exceeded configured maximum number of allowed output prompts, sections,Content Hello Experts, I had built a dashboard using the Absence Calendar Details Real Time subject area having two sections - Summary and Detail Analysis reports. I had…Akash Kiran Jana 27 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Run state new hire report.Summary Trying to find the navigation to run the state new hire report.Content New to HCM Cloud. Can someone point me toward the navigation for running the new hire repo…Mike Matchinga 109 views 8 comments 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM
-
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar…
-
Document Records Details and Corresponding ApprovalsSummary Document Records Details and Corresponding ApprovalsContent Hi, Are we able to produce a report which details the Document Records and the corresponding Approval…
-
Need to generate audit report for Person and Assignment EFFContent I need to be able to run the 'Generate audit Report' Scheduled Process for changes made to both an Assignment and Person EFF. I have turned it on and managed to …Jasmin S 55 views 18 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for HCM