Global HR
Discussion List
-
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
How to access deleted data information using BI Publisher?Summary: 22A Record Additional Data When Deleting an Assignment Record Using Employment Info Page indicates accessing the deleted data information in BI Publisher (PER_E…Viviane Beaudoin 21 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
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 54 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 61 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 31 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 21 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 135 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…
-
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 23 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 203 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 152 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 12 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 45 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o…
-
Need sample HDL for Contact Relationship (To Upload Dependent Information)Summary Need sample HDL for Contact Relationship (To Upload Dependent Information)Content Hello Everyone, Can you please provide sample HDL file for adding employee depe…
-
PPM Selected Bank AccountSummary How to Find selected bank account under personal payment methodContent Hello All, When employee update their bank details by clicking into their existing payment… -
How to send UCM file as an email attachment using BI publisher reportSummary: How to send UCM file as an email attachment using BI publisher report Content (required): Hi Experts, We need to extract a PDF file from UCM and send as a email…Venkatesan 617 views 15 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM
-
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 21 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…AjayKumar Maddipati 217 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM