Global HR
Discussion List
-
How to configure reminders for workflows notificationSummary: How to configure daily reminders for approval workflows notification if no action is taken from approver Content (please ensure you mask any confidential inform…Gleamy Mishra 82 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to get the Unique values in the table based value set query ?Summary: I need to get the List of unique manager name based on all the associates. But I couldn't use the distinct or any to get the unique value. Is there a way to han…
-
How to create sub departmentSummary: How to create sub department Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Sni…Gleamy Mishra 101 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
OTBI REPORT- ERROR WITH COMPENSATION SALARY REAL TIME DETAILS SUBJECT AREASummary: Hi All, when I try to add the Annualized salary and salary currency to an employee with a changed salary we find the following issue: 1. adding only the annuali…GiovanniD 41 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there syntax in OTBI I can use to round down?I have age in years as 22.6 which I need rounded down to 22. Using ROUND rounds up to 23; applying data formats rounds up. e.g: ROUND((CURRENT_DATE - "Workforce Manageme…Clare Murtagh 41 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 31 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Extract text data from "SuccessCriteriaText" in "XML_DATA_CACHE" column "HRC_TXN_HEADER" tableSummary: Does anyone know how to extract text data from "SuccessCriteriaText" column in "HRC_TXN_HEADER" table? Although I could extract some text data such as GoalName,…S.Watanabe0110-Oracle 161 views 1 comment 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Bell notifications are not getting triggered if username and work email IDs are same.Summary: Bell notifications are not getting triggered if username and work email IDs are same for assignment projected end date alert. Content (please ensure you mask an…Siddhesh Nisal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
Locations Child Data Group returning records at unexpected eventsWe've a changes only extract to retrieve person, assignment data. In assignment DFF, we've utilized 1 for Site-location(Attribute1) which LOV is retrieved as internal_lo…
-
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…David Boudreau 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 302 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Extract Error The payroll relationship action ID isn't valid.Summary: A system error ORA-20001: The payroll relationship action ID isn't valid. Contact your help desk. ORA-06512: at "FUSION.PAY_REPORT_BALANCE_GROUP", line 2462 ORA… -
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status …
-
Manager Hierarchy starting with CEOSummary: We are looking to get the manager hierarchy with CEO as level 1 of the organization. The Flattened Hierarchy table (PER_MANAGER_HRCHY_DN) has data with manager …User_2025-03-07-06-12-02-972 181 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we have Mail Triggers, once Extract has run successfully,Full Profile, Extract has been created to do HDL Upload Query : Mail trigger to happen once Extract has run to know how many cases have been failed.
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Check Working Day QuerySummary: Dear All, I have a requirement to check if a specific date is a working day for the employee or an off day. So basically I need a query with a parameter called … -
Need to Add board members in system and Pay Quarterly onceSummary: My requirement is to add Board members in System who are not actually employees and i want to pay them only Quarterly once. what is the Best way to achieve this…Laxman Doppalapudi 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Data Not fetching when joining cross subject areas with a DFF attributeSummary: We have encountered an issue while join two cross subject areas. Workforce Management - Worker Assignment Real Time and Workforce Performance - Performance Rati…Atul#620 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We updated our integration URLs with workers api but not workingSummary: We have rebuild our integration URLs with Worker API but when we are testing getting error like: "Request parameter expand with value workRelationships.assignme…mohityagyik 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How is Audit Table of HCM different from events captured in hrc_evt_source_objectsSummary: How is Audit Table of HCM different from events captured in hrc_evt_source_objects and which one should be used when Content (please ensure you mask any confide…Amod Kulkarni 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I find out the end date used for a scheduled process that has already endedSummary: We are trying to find out the end date used when a process was scheduled that is already in "finished" status. One of our ESS jobs has stopped running and we wa…Jefferson Yuliat 81 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM