Global HR
Discussion List
-
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 32 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
How to fix legislation code in table per_person_names_f_v?Summary: The following query gives two different legislation codes for the same Employee due to which the extract doesnt pull the gender information for that employee: p…Shilpa Varghese 218 views 1 comment 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 606 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 22 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
When we select Other as a disability category, a text box should appear in UISummary: When we select Other as a disability category, a text box should appear in UI. How to configure this requirement? Content (please ensure you mask any confidenti…Gleamy Mishra 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Restriction of DOR to dependents only and not employeesSummary: Restriction of DOR to dependents only and not employees. Eg: Birth certificate is required for birth of the children not employee. Only dependents Content (plea…Gleamy Mishra 22 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Reporting in UTC Time Causing IssuesSummary: Hello, We noticed that employees were showing as Terminated in OTBI before the end of the day (11:59pm) of their last day. The UI still shows an employee as Act…
-
ERROR MESSAGESummary: I can't submit Overtime Request from a Doc of Record Step up attached below: Content (please ensure you mask any confidential information): Version (include the…ahmed foly 23 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
In case of termination, there is a requirement to show last payment date.Summary: In case of termination, there is a requirement to show last payment date. Can anyone please guide on which oracle delivered field its captured? Content (please …
-
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
how to remove a certain value from drop down of a field.Summary: how to remove a certain value from drop down of a field. Eg: in below ss Content (please ensure you mask any confidential information): Version (include the ver…Gleamy Mishra 66 views 5 comments 0 points Most recent by PriyankaAgarwal -Oracle Human Capital Management
-
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 329 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
How to know input values supported by any fast formulaContent Hi All, Like we have query to get context supported by fast formula, do we have any similar query or table that can help to fetch input values supported by any f…Avinash 42 views 4 comments 1 point Most recent by Ann Van Roosbroeck Reporting and Analytics for HCM -
Manager not appearing in Termination reportContent Hi, We just recently implemented Oracle Fusion HCM and still trying to work some issues out. One of the issues when I try to pull a termination report that I cre…User_2025-01-23-20-22-05-099 98 views 11 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 23 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 50 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 65 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 42 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 34 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 23 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 136 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 12 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