Global HR
Discussion List
-
HCM Extract and Bi Publisher delivery option auditHi Whatever change has been made to the delivery option in both HCM extract and BI Publisher. Does the change and the user who made changes gets audited?? If Yes, could … -
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 230 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 63 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 23 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 23 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 24 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 182 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 25 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 24 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 479 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 577 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 28 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 419 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 13 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 44 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 34 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 14 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 4 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM