Global HR
Discussion List
-
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…a.w.anand 2.8K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM -
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Trying to Retrieve the Specific Ethnicity Record Associated with each Period of ServiceSummary:It appears that there is a separate row in table per_ethnicities for each of an employee's period of service. Looking for a query Content (please ensure you mask…ChicagoConsultant 3 views 1 comment 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
Recently updated data in an Org Tree is not displayed in OTBI reportsSummary: In mid December, I created about 20 new departments and tied them to existing Divisions in an Organization Tree. The departments were created with a 1/1/25 effe…
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 27 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Approvals are in progress. Info is lockedHello, I am trying to transfer an employee from one legal entity to another and I am getting a message that approvals are in progress. I tried to run the Conflicting Tra…Catherine Abi Samra 354 views 6 comments 0 points Most recent by Rahul M Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 540 views 6 comments 0 points Most recent by Melek Cinar 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…
-
How to end date Job & Position using HDLSummary: How to end date Job & Position using HDL Content (please ensure you mask any confidential information): Hi All, Is it possible to end date/delete Job and Positi…
-
PDF available for Tables and Views for HCMSummary: Is PDF option available for Table and Views i see there is no option to download. Tables and Views for HCM Content (please ensure you mask any confidential info… -
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 680 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
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 134 views 1 comment 0 points Most recent by Ramanathan Sockalingam 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 17 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…
-
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 19 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…
-
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 28 views 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
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 66 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 40 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 260 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 7 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
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 244 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 930 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…
-
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 323 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… -
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …Pavan Kumar Thummalapalli 160 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM