Global HR
Discussion List
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…Anuroopa Sahoo 87 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Reporting and Analytics for HCM -
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend …
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Pradnya_Pampatwar 401 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 1.8K views 9 comments 0 points Most recent by Naveen kumar 99 Reporting and Analytics for HCM -
Requisition Staffing agency fields in OTBI do not show any dataSummary: Requisition Staffing agency fields in OTBI do not show any data Content (please ensure you mask any confidential information): Recruiting Real time Subject area…FuriousSS 1 view 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…Oriana L. 1 view 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
Is there a way to restrict delegation UP the hierarchy?Summary: Is there a way to restrict delegation UP the hierarchy? If a manager delegates to one of his direct reports, employees are able to approve their own ICPs. We ha…
-
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu…THawkins_LGI 118 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Reporting only role - OTBISummary: Content (please ensure you mask any confidential information): Are there any ootb reporting roles which just grant access to the OTBI layer and restrict all oth…Clare Murtagh 14 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Oracle Global Human Resources Cloud Learning SubscriptionHi All, I am planning to go for the Oracle Global Human Resources Cloud Learning Subscription, have some clarifications, i) Do we have any instructor led sessions. ii) D…Hari Krishnan Subban 1 view 2 comments 0 points Most recent by Hari Krishnan Subban Reporting and Analytics for HCM
-
Report submitted in Scheduled Process going to Error stateSummary: Content (required): Hi All, BI report configured under 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applic…Anil Pillaresetty 121 views 1 comment 0 points Most recent by larachalak Reporting and Analytics for HCM -
Is there a way to join a "Workforce Management - Areas of Responsibility" SA with "Recruiting RT"Summary: Is there a way to join a "Workforce Management - Areas of Responsibility" SA with "Recruiting - Recruiting Real Time" SA to get proposed representatives for the…Volodymyr Faranosov 11 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
cant find the role assigned date in Security Audit Real Time subject areaSummary: The ask is through the Security Audit Real Time subject we can't find the role assigned date since it has the role details we can't get the role assigned date d…sunas 41 views 8 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
OTBI report is taking too much timeSummary: Unable to run Time Card Status Report Content (please ensure you mask any confidential information): We devloped custome OTL report. When we are running for one…
-
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 73 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
OTBI Leave of Absence Report - No Absence ModuleSummary: Hello, We are trying to use the Assignment Event SA to build a report that will reflect all of the employees who are currently still on Leave of Absence and hav…CCannadayCTR 42 views 11 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Talent HCM Extract: In value set want to return multiple rows.Summary: for each employee under talent profiles there are some languages which person added for each language there is one content_item_code from table 'HRT_CONTENT_ITE…Abhijeet Kambare 31 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Report Data PurgingSummary: How often your organisation request Oracle to purge the report job history? Content (required): We have reviewed the report job history and have noticed there a…Sejal R 81 views 2 comments 1 point Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCMSummary: Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. Content (please ensure you mask any…Hitha Harikumar 845 views 16 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to convert data rich text format to plain text in BIP.Summary: Am getting below output for one of Field format,:1. Words: 17Characters (with HTML): 897challa praveen 95 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 265 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
what is the name of column and table under which I can find address typeSummary: what is the name of column and table under which I can find address type (e.g. current,mailing,home)etc of a person ?Since I need to add fetch data of person ha…
-
Grade null for Job requisition OTBISummary: Grade null for Job requisition OTBI Content (please ensure you mask any confidential information): Hello experts, we are building an OTBI report with "Recruitin…
-
The 'termination category' stopped working in OTBI in 24ASummary: The 'termination category' field in the 'workforce management - work relationship real time' subject has stopped working for me in OTBI. I created a report in m…
-
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 22 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM