Global HR
Discussion List
-
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 321 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 366 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 37 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 -
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 495 views 11 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for HCM -
Redwood hire an employee, can i set the Toggle(s) on/off by default?Summary: Hello, So my question is; our HR department when creating a record on Oracle for a new starter would always want to use the same screens and therefore would alw… -
Can we add a textbox (Number) as runtime parameter in OTBISummary: Hi team, Can anyone please confirm if, we can create a text box as run time parameter and we need to use that runtime parameter in one of the Column formula. Pl…Sagar Perala 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need to Split Job.Job Name into 3 different fields - Primary, Secondary, TeritiarySummary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as Primary Secondary Tertiary Unmapped Unmapped HEAD OF AGRICULTU…Pradnya_Pampatwar 21 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 597 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM