Global HR
Discussion List
-
Assignmentrecords exist prior to the hiredate.Either delete assignmentrecords or change the hiredateSummary: While trying to change the hire date of an employee through HDL getting below error Error: Assignment records exist prior to the hire date. Either delete the as…Aruna Aounti -Oracle 5 views 0 comments 0 points Started by Aruna Aounti -Oracle Reporting and Analytics for HCM -
Usage of "Employment Start Date" quick action and "Work Relationship" quick action.Summary: Some of the Oracle document suggest using 'Work Relationship' quick action (instead of 'Employment Start Dates' quick action) to correct the start date of the p…
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 81 views 6 comments 0 points Most recent by Bayan Khalaf Reporting and Analytics for HCM -
disable_date not populated in HR_ALL_ORGANIZATION_UNITS_X after inventory org is disabledHi Team, We have disabled the inventory org and we are checking below condition but org.disable_date is not populated. Can you please help how we can populate org.disabl…vikram khengare 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
What is the fast formula definition for Enterprise Hire dateSummary: I'm building a fast formula that will pull the Enterprise Hire Date of an employee for an eligibility profile. Need your help please. Content (please ensure you…
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…
-
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat…Shawn McDonald 115 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
REST API to get worker assignment historySummary: How to fetch Worker Assignment History details using REST API Content (please ensure you mask any confidential information): The requirement is to fetch Worker …
-
Document Category is salary infomration notification issue redwoodwe have DOR with Document Category, which is salary information. For this DOR, we have created a DFF. When employee submits DOR, line manager cannot see DFF values in ap…
-
Need to get Original Start Date on Report with Data ModelSummary: We have a Change Report but need to add Orig. Start Date - OSD. The report is based on a Data Model and I'm not sure what the coding is for OSD or how to get th…Nancy Pearce 17 views 3 comments 0 points Most recent by Nancy Pearce Reporting and Analytics for HCM -
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…Venkatesan 37 views 2 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 83 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
I was trying to create a report to pull employees, excluding the managersHow to pull employees using OTBI and to exclude managers who are also an employee. please share ideas thanks.Joliver Caangay 23 views 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu…
-
Editing PersonHeader subtemplateHello. I'm trying to customize the PersonHeader subtemplate and is already in the Shared Folders/Custom/Human Capital Management/ Workflow Notifications. But when I chan…Maria Cristina L. San Jose 61 views 2 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
Seeking documentation to code for HR Org hierarchySummary: Hello All, I see that Fusion utilizes the following tables to manage HR organizations and their hierarchies: - HR_ALL_ORGANIZATION_UNITS_F (internal CDEE_FSCM_O…
-
How to customize the sub template for Termination Report?Summary: How to customize the sub template for Termination Report? Content (required): Hi All, How to customize the sub template for Termination Report? Where I can find…Venkatesan 33 views 4 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
Error : An application error occurred. See the incident log for more information.Summary: Is there any way to retrive log for error message : An application error occurred. See the incident log for more information. Content (please ensure you mask an…Muzammil Aman Siddiqui-Oracle 23 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
When the customer is trying to edit salary information from Salary History Page and then submittingSummary: When the customer is trying to edit salary information from Salary History Page and then submitting it they are getting error "" An application error occurred. …Muzammil Aman Siddiqui-Oracle 5 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
Document record request, details are not reflecting on Supervisor's notification page.I'm raising a Document Record request from an employee user but in supervisor's notification page the document details are not reflecting in the document details column …
-
PER_PERSON_SECURED_LIST_V View Does not Retrirve all RecordsSummary: PER_PERSON_SECURED_LIST_V View Does not Retrieve all Records. It fetches the data of only the Current logged in user. Please advise Content (please ensure you m…MilanMohanty 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Analysis Columns displayed by prompt valuesHi Experts, We have a balance report that works well. However, we would like to display in it some context based assignment DFF's. We would like to keep 1 report for eac… -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 463 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
I want to add custom text in workflow notification which should be sent to initiator aloneSummary: I want to add custom text in workflow notification which should be sent to initiator alone.Is that possible? Content (please ensure you mask any confidential in…
-
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.Mohamed Eliyas 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 131 views 14 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 22 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s…