SQL
Discussion List
-
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination… -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro…Faizan Rashid 27 views 1 comment 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
SQL to calculate overall tenureSummary: Content (required): I am working on a BIP report and I would really appreciate if I get some help with the SQL to calculate the overall tenure of the employee w…Prajna Hegde 48 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Which table stores absence eligibility details?Summary: Which table stores absence eligibility details? Content (required): Hi Team, I want to know the table which store absence eligibility profile details. Thanks. V… -
Person number of employee/contingent worker of a successful referred candidateSummary: Customer is looking for a report with the person number of the employee/contingent worker who has been successfully hired after being referred by an internal em…
-
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.6K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
SQL Help for Dates crossing into New YearSummary: HI All, I have a requirement to pull a list of dependents that will be turning 21 within 6 weeks (ie. If I run the report today, I should be pulling into those …User_2025-02-04-08-51-08-912 26 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 23 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes …Janardhana Kondaveeti 136 views 5 comments 15 points Most recent by Visu Reporting and Analytics for HCM -
Need Help to fix Date parameter while integrating BI report into DashboardSummary: I have created a SQL with a date parameter that calculates effective date minus 5 days. Below is the code which is working well while running normally with BI r…Mohan Murali 81 views 1 comment 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
How to map an Subject Area Field to an Oracle tableSummary: I am trying to find the table that holds the company name for our contingent worker the field that I am trying to map to SQL is I thought the data would be in t…User_2025-02-04-08-51-08-912 49 views 9 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
SQL or tables for Resignation Workflow Approver historySummary: Resignation Workflow Approver history Content (required): Hi all, I need to pull our the workflow details of Resignation workflow in BI. So please let me know f…Aditya Lanka 417 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.7K views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 35 views 1 comment 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 40 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
How to see multiple values in new line in Oracle SQLSummary: Content (required): I need to develop a BIP report for talent profiles. As per the business requirement, I need to display multiple values (Ex. Skills, Language…Prajna Hegde 25 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 205 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is …
-
How to join 2 tables without common column in SQLSummary: Content (required): How to join 2 tables without common column in SQL and get the columns from both the tables side by side? I tried using the CROSS JOIN and UN…Prajna Hegde 38 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 26 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Seeded report to get every earning/deduction/taxes of any specific employee during a date rangeSummary: Need to know if any seeded report exist that we can leverage to get details of every earnings/deductions/taxes of any specific employee during a pay period or f…
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
How to Burst a BIP report (Excel format)Summary: Hi All, I have a business requirement to send an attachment to each of our vp's with their employees I have created a SQL with my information that has a paramet…User_2025-02-04-08-51-08-912 1.2K views 6 comments 1 point Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Back end table storing Costing type and Distribution groupSummary: Please share the back end table and column names storing costing type and distribution group name Content (required): HDL load fails with message A distribution…
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 27 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 2.7K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
OTBI reports doesn't display all the information loaded in the systemSummary: Content (required): Hello experts, we have noticed that some OTBI reports display 25000 rows at maximum and some information is missing. We suppose that for rep…