Global HR
Discussion List
-
Manager Self Service ReportingQuestion: For MSS, did you enable self service dashboard reporting via OTBI? How did you reference trend analysis? Thank you.Clare Murtagh 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …Clare Murtagh 34 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Using OTBI Analysis, how can we append sysdate (MM-DD-YY) to the filename?Summary: Using OTBI Analysis, how can we append the date (MM-DD-YY) to the filename? Content (please ensure you mask any confidential information): Can we append sysdate…SUSAN SANDIFER 53 views 5 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
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 49 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 232 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 812 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 21 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 22 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 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Assignment Details in WP TableHi, Looking into the HTS_WORK_PATTERNS_B I am not able to find the person id/assignment id of the records for whom the work pattern is created. How can this be looked in… -
DELETE Work Pattern using HDLHi, Can someone share sample HDL file for deleting existing work pattern, shifts and breaks. Thanks -
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 21 views 1 comment 0 points Most recent by Rambabu Laveti-Support-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 71 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 332 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 44 views 4 comments 1 point Most recent by Ann Van Roosbroeck 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 21 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 32 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 81 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 104 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