Global HR
Discussion List
-
Add 'Attribute1' column from the PER_PERIODS_OF_SERVICE table into the dependent PVOHi Team, Could you please help How to add the 'Attribute1' column from the PER_PERIODS_OF_SERVICE table into the dependent PVO "HcmTopModelAnalyticsGlobalAM.AssignmentAM…Divya Penmetsa-Oracle 11 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle HCM Extract -
can we add filters for checklists tasks also in hcm extractswe wan to create DOR if the termination/resigantion checlists tasks are completed. Can we add filters for those also in HCM extracts. which bussiness object we need sele… -
Best approach to implement security in worker hcm extractSummary: We are developing a Worker HCM extract to pull worker demographic information in changes only mode. There should be options to run this extract by client from l… -
Created a Changes Only extract– contains historical data on Assignment detailsSummary: Hi Teams, Need to get history data from assignment using HCM extract, Root UE: GLOBAL_PAYROLL_INTERFACE_TERMS_UE Childs 1: PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE Ch… -
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
can we perform any arithmetic operation like sysdate - 20 in alert templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Pooja Ghosh 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How to export HCM Audit Reports in OTBI?We couldn't find where to export seeded Audit Reports. Does anyone one how can we access?Serap Aktaş 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE fetching previous day changed employee in next day runSummary: We have created a changes only extract where we used PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE as root UE along with multiple child UE. Requirement is to send data w… -
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 11 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Custom Schedule Reports,BICC extract and Custom HCM Extension also impacted on emps to workers apiSummary: I have concerns regarding emps to workers api change, Below objects also impacted or not Custom scheduled reports? BICC extracts? Custom HCM Extensions? Content…mohityagyik 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 51 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
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 111 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 411 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM -
24A Changes - Unable to edit HCM Extract attribute nameSummary: After 24A , Whenever we create a new attribute to extract record the name of attribute is defaulted to database item name. We are unable to edit attribute name … -
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 12 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 151 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 11 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 -
Why does partial or full rebuild of an extract fix missing data problemsSummary: We sometimes find that our extracts are missing records that should included. Running the UE and filter sql shows the data should be present. The data is not pr… -
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 51 views 8 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM