Global HR
Discussion List
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 11 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Is there a way to extract filter criteria for multiple extracts in one goSummary: Is there a way to extract filter criteria for multiple extracts in one go Content (required): Hi Team, Greetings! We are checking for the HCM extracts which use… -
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 51 views 10 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …Santo Campione 21 views 2 comments 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
Mass printing of Performance Documents is not translatedSummary: Our current language on HCM is italian, but the mass printing is in english language Content (please ensure you mask any confidential information): Is there a w…Giuseppe Casalino 21 views 2 comments 0 points Most recent by Giuseppe Casalino Performance Management -
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 51 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is there a SQL query to get employees processed in extract run?Summary: Is there a SQL query to get employees processed in extract run? Content (please ensure you mask any confidential information): there a SQL query to get employee…
-
How to know from front end which field is available in which back end table in oracle fusion cloudSummary: Creating a Report on Apprenticeship. Content (please ensure you mask any confidential information): Need to find data in the Oracle tables for Apprenticeship. H…Pradnya_Pampatwar 521 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Is this possible to track deleted person dependent/contact information through hcm extract.Summary: Is this possible to track deleted person dependent/contact information through hcm extract. I have searched but didn't get any information. Please provide some …
-
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Columns as stagesSummary: im trying to find a way if possible to wrap a whole column in an arrow pointing right. I have multiple stages and want to flow from stage1 to stage5. The two wa…
-
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 11 views 0 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Original Hire Date Changed for Pending Worker vs. EmployeeSummary: Our original hire date was historically based on the work relationship start date. However, after the implementation of ORC it is now the effective date of the …Chad Morris 321 views 7 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
Custom HCM Role AuditSummary: How to get Audit report for Custom HCM Role Content (please ensure you mask any confidential information): I want to know that who made changes to the data secu…ArunSolanki18 1 view 1 comment 0 points Most recent by John Thuringer-Oracle Reporting and Analytics for HCM
-
HCM Extract to fetch Absence Day wise breakdown detailsHi We are trying to integrate Absence data from Fusion HCM with Ramco Payroll and looking to extract absence day wise breakdown details using HCM Extracts as only modifi…
-
How to get person extra information field value in fast formulawe have a requirement to compare two values one is element input value and another one is from person extra information field value and give maximum value into an elemen…
-
Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to stop BI Workflow Notifications (Personal Information - Disability Info) in Fusion HCMSummary: A BI notification is triggered when an employee enters Disability Info (Navigation Person Details -> Disability Info). We can see there are a couple of seeded B…
-
BI Report to show all Employee/Manager HierarchySummary BI Report to show all Employee/Manager HierarchyContent Hi Community I am trying to build a report which shows all employees and their managers.. I need it to sh…Kunal Daya-175386 521 views 3 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesSummary organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesContent HI Team, report has to be developed in the column format parent_n…Hanuman Chennamsetty 3.4K views 3 comments 2 points Most recent by Shrikant Gupta Reporting and Analytics for HCM
-
Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 89 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Report to confirm those that do not have a probation keyedHello, Has anyone built a report to show those that do not have a probation keyed? I have tried building one based on anyone that has the action reason 'end probation' a…
-
Act as Proxy Manager for Line Manager DashboardSummary: As an HR user with view all, I am unable to proxy the line manager view what they can see in their own dashboard. In Workforce Compensation, there is Act as Pro…Sonia Canumay 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM