Global HR
Discussion List
-
we joined two subject areas but when we apply single country it is woking fine but multiple not workSummary: Hi All, we joined two subject areas but when we apply single country it is woking fine but multiple not working. stlll searching mode ? subject area: workforce …AjayKumar Maddipati 22 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 45 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Issue with extract for termination detailsSummary: We are using this extract from couple of months back . It is working for all other employees. Only 2 employees facing issue with termination details , we could …Vishnupriya 33 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to fetch Resignation/Termination withdrawn after last working dateSummary: Hi, There is a requirement to pull all the employees who has withdrawn the resignation/terminations after the last working day need to include pending for appro…Aruna Aounti -Oracle 3 views 0 comments 0 points Started by Aruna Aounti -Oracle Reporting and Analytics for HCM
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 13 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to trigger notifications to the Mobile Numbers instead of Email IdSummary: Hi Team, We know that the notifications will be triggered to Email IDs through bursting and the customer asks to trigger the notifications to the employee's mob…Dasari Dileep 1 view 2 comments 0 points Most recent by Dasari Dileep Reporting and Analytics for HCM
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …Valerio Curzi 2 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…Valerio Curzi 12 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…Valerio Curzi 100 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…Valerio Curzi 346 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time - no data being returnedSummary: Trying to build a report showing employee bank account details from SA 'Payroll-Personal Payment Details Real Time' - I have the required roles (Payroll Mgr etc…
-
If a EFF does not have a value is there a way to pull it into reporting?Summary: We have some positions that have Extensible flex fields entered for Background checks and Licenses - but some of the positions do not have this yet (so essentia…THawkins_LGI 61 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…Valerio Curzi 184 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
HCM Position HierarchySummary: Hello, I created an OTBI using Position Real Time subject area but I am not able to get the desired results. Example, I have below position hierarchy Position1 …HetalVaghela 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 22 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
HCM Reporting/Extracts usage recommendationsSummary Out of plane vanilla sustainable reporting ideas for HCMContent Disclaimer: following post expresses personal opinion of author based on many years and many rele…Valeriy Gorbunov-80491 70 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Canada's Employment Equity Questionnaire (Legislative Requirement)Summary: Hi Team, I would like to ask for your thoughts if you have configured or added this legislative requirement of Canada to the system? It's like a set of question…KarenA 12 views 1 comment 0 points Most recent by IoanaNatalia-Oracle Reporting and Analytics for HCM
-
Personalization of help desk requests page in redwoodSummary: We have requirements to personalize help desk requests page to split category field to category and sub-category, noting that the page is redwood and personaliz…
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Where to find/add Brazil Job Details attribute values ?Summary: I am not able to find this Brazil Job Details values in Job Details/Jobs page. I believe its an attribute under a delivered DFF attribute (as shown in the Desig…Anshuman Chatterjee 48 views 5 comments 0 points Most recent by Anshuman Chatterjee Reporting and Analytics for HCM
-
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 374 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Impossible to cancel work relationshion because already terminatedSummary: We have a work relationship that needs to be cancelled but is already terminated, we can't reverse the termination because the employee has a second work relati…margherita bonfiglio 15 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…Henry Imgrund 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a…Cansel Karasoy 22 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I get the Home Address from the Person Management\Person area on a ReportSummary: I have the mailing address, but need the home address. Content (please ensure you mask any confidential information): Version (include the version you are using…