Global HR
Discussion List
-
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 46 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 42 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 2 views 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 23 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 192 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 24 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
-
DFF in termination under PER_PPS_DF which subject area can we report from?Summary: We have added a DFF to termination under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from? Content (please ensure y…Sharon Ferguson 21 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 12 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
How to pass NULL and All column values prompt values in logical sqlSummary: Hi, I have created a dashboard prompt but when I am passing values as NULL and All Column values in prompt analysis is showing no result. I have created analysi…Shreya Datir 41 views 18 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…AjayKumar Maddipati 6 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …Farah Alajou 90 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 50 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Dynamic generation of URL (from OTBI) to Person's Person Management in HCM ApplicationContent Hello, Just wanted to check if anyone tried to generate a dynamic URL from an OTBI analysis that can go to Person's Person Management screen at HCM Application. …SantoshKumarBhairi 238 views 33 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than…
-
Birthday Notification to be sent with Custom text on ImageWe have requirement to send birthday notification to employee by keeping RM , HRRM , Employee direct reportee and RM direct reportee in CC The content of email is :- Dea…Surbhi Jat-Oracle 87 views 0 comments 0 points Started by Surbhi Jat-Oracle Reporting and Analytics for HCM
-
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
BIP report date format is not working in Dashboard promptsContent Hi All, I have created a BIP report with date parameter and it is working fine. When I tried to apply dashboard column prompts on the same report data is not fet…Sachin.Satpute 80 views 4 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 36 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM