Global HR
Discussion List
-
Unable to see newly created elements in OTBI reportSummary: I am using the attached report and am able to see elements on employees/pending workers. We recently created some new elements, and I can't get them to pull eve…Shanna Oppenheim 21 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
V3 Seniority Dates in OTBISummary How to report on V3 dates in OTBIContent Hello, We're migrating to the V3 seniority dates with the release of 20B, but we're running into a number of reporting i…Whitney Van Way 93 views 8 comments 1 point Most recent by THawkins_LGI Reporting and Analytics for HCM -
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 11 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM
-
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct…
-
How to handle "Personnel File Request" in Oracle HCMSummary: Hello, Per Personnel Records Review Act, Current and Former employees can request their Personnel File information from the employer. I would like to know the f…Deepa Kannan 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
send alert to employee department headwe need to Alert notification to employee department Head, could you please assist on this
-
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 75 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an…
-
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Trying to invoke candidate attachment REST API through PL SQL procedure giving errorSummary: Trying to invoke candidate attachment REST API through PL SQL procedure giving error " PLS-00306: wrong number or types of arguments in call to '||' " v_buffer1…
-
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 31 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 41 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…
-
How can I activate audit trial on PER_CONTACT_RELSHIPS_F tableSummary: How can I activate audit trial on PER_CONTACT_RELSHIPS_F table Content (please ensure you mask any confidential information): Version (include the version you a…Farah Alajou 41 views 12 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
What is the Subject Area for News and Announcements (which are displayed on the user home page)?Summary: We have a requirement to show employee announcements in an OTBI dashboard, so we want to know the subject area for the same. Content (required): Subject Area fo…Bhukya Vamsi Naik 41 views 4 comments 0 points Most recent by gguittini Reporting and Analytics for HCM
-
HCM Extract by Business UnitSummary: I'm looking to filter multiple HCM Extracts by Business Unit ID. I seen there was a similar ask in 2017. I'm looking to do the fast formula route, as I presume …User_H77SF 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to fetch the journey task status of the preceding task within a journey task?Summary: Currently we are configuring a journey with few tasks (say 1 to 5). Condition for task 5 - If task 4 is not completed then task 5 should trigger. How can we ach…
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
Number of active/Inactive users in Oracle HCMSummary: Hi All, Do we have any standard report to see the number of active/inactive users in the system? If someone has this report please share. Thank you.Saher 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…Shilpa Varghese 173 views 4 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…
-
Query to retrieve the employee seniority dateSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve Seniority Date for employee person number 1775. In case of Rehir…Valerio Curzi 21 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can we delete an assignment from oracle fusion?Summary: Example : Lets assume E000001, E000001-2, E000001-3 assignments are present in the system with same legal employer. Can we delete E000001-3 completely from orac…Sanju Jana 21 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Rcount sort orderSummary: I need to know what controls the sort order for the RCount function. I have a requirement to select one assignment per person from worker assignment real time S…
-
Job Offer Letter Template LimitSummary: Content (please ensure you mask any confidential information): Hello, My TA team was curious if there is a limit on the total number of Job Offer Letter Templat… -
We are looking for options to connect to the HCM database from external application eg. ExcelSummary: We are looking for options to connect to the HCM database to pull employee and org data to simplify some of the processes for our HR. Content (please ensure you…Vijayalakshmi_H 21 views 3 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for HCM