Global HR
Discussion List
-
Worker Data Load (HDL) TIPS requiredSummary: Need a checklist while loading Worker data Content (please ensure you mask any confidential information): Hello Everyone, I'm new to loading HCM data, including…Lucky Sharma 21 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL) -
Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM CloudSummary Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM Cloud – A Worked ExampleContent The business requirement is to cre…AshishERPCloud 120 views 3 comments 5 points Most recent by Dasari Dileep Reporting and Analytics for HCM -
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 21 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Protecting Sensitive Data in Custom ReportsWhat is the most effective way to provide managers with access to custom reports without exposing sensitive employee data, such as ethnicity, date of birth, home address…Rashi_Churiwala 16 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Public Holiday Report in BI PublisherSummary: Anyone has a sample SQL Code for the Public Holiday Report using BIP? I am currently having trouble connecting the PER_CALENDAR_EVENTS_VL to Node IDs to get the… -
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI subject area for Document of Records descriptive flexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we created custom fields within document type and we mapped them in OTBI. Where ca…Valerio Curzi 170 views 6 comments 0 points Most recent by Becca Edwards Reporting and Analytics for HCM -
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
Person Seniority Real Time not showing resultsSummary: The "Person Seniority Real Time" subject area is not returning any results, even though we're currently using the Seniority Dates V3. Does anyone have a solutio…Martijn van den Berg 11 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Query to get users deleted rolesContent Hi All, I am trying to fetch details of roles assigned to a user including the one deleted in the past. In ebiz we only had option to end date a responsibility b…Avinash 795 views 16 comments 2 points Most recent by Vijay Ramani VJ Reporting and Analytics for HCM -
What is the table name stored allocated task code?Hi I need to get the allocated task code but I can't find it in PER_ALLOCATED_TASKS and PER_ALLOCATED_TASKS_TL table, I can find only TASK_NAME but can't find TASK_CODE.…Mohamed Salah 22 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 44 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
EU Pay transparancySummary: We looking for a report to analyze the pay transparance between genders as requested by EU. Has anyone seen or created a report showing variances in payment per…Wouter.Schaap 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 141 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
SQL to get Cost center mapped to countrySummary: Hello Everyone, I just want to ask for SQL on how to get the cost center who are mapped to country. Thanks,Michael_B 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is there a way to find out if the users really using the current assigned role that they have?Summary: In the Fussion application, we can pull list of users who has a certain data role. But we wanted to know who among those users in the list that are actually usi…Lorejean Gelacio 33 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…Rajesh Suvala85 21 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Navigate to a Web Page (from OTBI) - dynamically changing POD reference in URL?Summary Navigate to a Web Page (from OTBI) - dynamically changing POD reference in URL link to HCM Fusion application page?Content We are using the "Action Links" -> "Na…Chris Lloyd-135625 296 views 18 comments 3 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM Auditing/ Audit reportSummary: Hi ALL, We'd like to understand what auditing is available and how detailed auditing would be enabled. It may just be an OTBI report, it may require some settin…RamkumarKadhiravan 17 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
SSN not removed from headingContent I want to modify alert notification template, where when employee update their contact relation, their SSN number should not be visible to approver. However when…Aanila Nanda-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
HR Audit reportSummary: Hi All, I have a question regarding the HR Audit report feasibility. If HR were to identify sensitive data, is it possible to enable auditing on a handful of sp…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?Ronel M 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
Which view/tables to access to create a report to capture User Login IP Address?Summary Which view/tables to access to create a report to capture User Login IP Address?Content IP Address of Application user in Fusion HCM is to be captured in a repor…Setu Shah-27233 303 views 11 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for HCM