Global HR
Discussion List
-
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…User_2025-02-04-07-19-57-588 73 views 3 comments 0 points Most recent by Robert A Reporting and Analytics for HCM -
How to hide Team Activity Center -> Dynamic SkillsSummary: Hi How to hide in VBS the Dynamic Skills present under Team Activity Center as shown below Content (please ensure you mask any confidential information): Versio… -
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 472 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 21 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 1.2K 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 21 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
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 51 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 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM Extract Notification - Email Generic User AccountSummary: Hi, We have a requirement for a HCM extract to email a generic 'service user' user account when the job fails in error or warning. The generic user does not hav… -
Need simple query to fetch all the active positions created in cloud without position treeCan anyone help me to modify the filter criteria of oracle delivered EPBCS_Position_Metadata_2002 extract to fetch all the positions without position tree. Current filte…
-
How do you display PER_PERSONS_DFF on Redwood Personal Details Page - REDWOODSummary: How do you display PER_PERSONS_DFF on Redwood Personal Details Page. They are not showing up in VB Studio? Is it even possible? Content (please ensure you mask … -
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
-
Existing Reports and Direct Report sections show up as Hidden and non editable in VBSSummary: Customer is asking to manage Existing Reports and/or Direct Report when performing a QA, but the sections are not non editable in VBS. is there a plan when thos…Antonella Genovese-Oracle 11 views 2 comments 0 points Most recent by Antonella Genovese-Oracle Visual Builder Studio for HCM
-
Adding new attribute to existing changes only extractSummary: Adding new attribute to existing changes only extract leads to full volume run Content (please ensure you mask any confidential information): Hi Team, Greetings… -
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 324 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
-
Changes Only Extract is not Picking up New Hires , Terminations and Changes for Some RecordsSummary: Changes Only Extract is not Picking up New Hires , Terminations and Changes for Some Records. Can any body give some Inputs to debug this and what could be the … -
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 31 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 31 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Inbound interface issue 24CHI Experts, After 24C patch upgrade in our instances we tested inbound interfaces what we saw is after all the steps completed (2/2) the generated HDL is failed to load … -
Projects in VBSHi All, Should we create new project while we need to use VBS or can we use the existing Project which is already created. If I use the already created project, will the…Dhilipkumaar-Oracle 31 views 4 comments 0 points Most recent by Dhilipkumaar-Oracle Visual Builder Studio 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 367 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 40 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