Global HR
Discussion List
-
Promotions and Transfers Reports and Data ModelsSummary: Business need for two reports: promotions and transfers showing From and To information Content (required): Hi, everyone. We are looking for an example of a rep…Michael Cashin 228 views 3 comments 0 points Most recent by User_VB02H Reporting and Analytics for HCM -
HCM Extract failing at runtime for Name PAY_PAYPROC_UNKNOWN_ERRSummary: Hello, The HCM Extract validated and compiled with no errors is failing at runtime for below mentioned errors: Name PAY_PAYPROC_UNKNOWN_ERR Token1 null Token2 n…
-
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 60 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would…Revital Mefano 22 views 2 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
How to "decode" Notice Period UOMSummary: How do one decode Notice_Period_UOM in SQL/Query Builder Content (required): How do one decode Notice_Period_UOM in SQL, so that the output display e.g. days, m…
-
HCM Extract Rule Extract related to FF - Logging helpSummary: How do you output log information from a custom Fast Formula that is run from a HCM Extract? Content (required): I have a HCM Extract with an attribute of type … -
Having an issue while opening Analysis with HR Specialist roleSummary: I have an issue when I'm trying to open an OTBI analysis from the user account with Human Ressource Specialist role. But no issues occurred when I open it from …Evgeniya Repnina 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
EEO and VETS Reporting Set upSummary: Hi All, I am trying to run the delivered EEO and VETS reports from My Client Groups> Payroll> Submit a Flow area . But nothing is appearing in the LE dropdown a…Gaurav Rath- PGC 22 views 3 comments 0 points Most recent by Gaurav Rath- PGC Reporting and Analytics for HCM -
How to use current system date as a prompt and bring current year value as a column in OTBISummary: Hi Team, I have a requirement to use current system date as a prompt in an OTBI and bring current year as a static value in a OTBI. Please suggest solutions. Th…
-
Subject Areas not fetching data properlySummary: "Workforce Management - Worker Assignment Real Time" subject area not fetching the data properly. Content (required): I am working in internal test instance, it…Raghavendra M 178 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 72 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create LOV for countries defined in the system and few more custom valuesSummary: Can we create an LOV that will include all countries already defined in the system plus few more custom values. Content (required): Version (include the version…
-
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 23 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM -
How to burst different notifications to different mail IDs based on exit interview responsesSummary: How to burst different notifications to different mail IDs based on exit interview responses Content (required): We have implemented the Offboarding Process in …
-
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 471 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Source System ID for Work TermsSummary: Sample Query to extract SSID for Worker.dat >>>> Work Terms object upload Content (required): We have a requirement to extract SSID of work Terms object for Wor…Dhajani Perera 570 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How do I access a .dat file that has been loaded into the systemSummary: I am trying to review file that was processed through our recruitment application but I can't figure out how to review the actual .dat file Content (required): …User_2025-02-04-08-51-08-912 25 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
User Login DetailsSummary: Hi I am looking for a BI / OTBI report that would give me the user login details. Content (required): I looking for a report that contains, User Name, Email, Pe…Manoj B. Cheruvathoor 414 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Dashboard over a Mulitple assignment HCM config - need to eliminate wrong result from dashboardSummary: VP is seeing an Indirect reports Director that is outside of Talent/Performance Goal Drill-down compared to User Interface for Performance and Goals (Talent) Co…John White-Oracle 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
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 44 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 13 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 2 views 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…