SQL
Discussion List
-
Calculated Eligibility fieldSummary: Hello, We're trying to extract the Calculated Eligibilty column in SQL, as we need to know the value if it's Forced Eligible or Eligible. However, we cannot fin… -
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 95 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 69 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
How to confirm the normal transmission of the bursting.Summary: How to check if a bursting has been successfully sent. Content (please ensure you mask any confidential information): Nice to meet you. My name is Keishi. Now I…
-
SQL query for linking between life event and benefits plansSummary: Need sql query or back end table for the linking of add life event(BEN_LER_F) and benefits plans(BEN_PL_F) Content (please ensure you mask any confidential info…
-
Query to retrieve the employee seniority dateSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve Seniority Date for employee person number 1775. In case of Rehir…Valerio Curzi 23 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 13 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
Looking for Department column which contain value of PSSR Requisition DFFSummary: I am looking for Department column which is populated with new value using DFF. Please find attached doc for reference. Content (please ensure you mask any conf…Pooja_123 21 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Query that fetch Grade Rate Value for a certain personSummary: Hello! I need help to get a query that passing the assignment_number of an employee I can get the value field of a Rate Value inside the Grade of a person. Exam…Matheus Roberto 40 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 31 views 5 comments 0 points Most recent by Rajesh Jupudi-Oracle Reporting and Analytics for HCM
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 42 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Milestone date showing as Hire Date in Long service Employees Report ?Summary: Hi Team We have long service employees report on who completed the 5, 10, 15 years like and we applied filter on as below. TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker".…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
SQL for Payroll Element Calculation FactorsSummary: Hi all, does anyone have any SQL that extracts element calculation factors? Element Name, Calculation Step, Calculation Value Definition, Range Values etc… Than…Jon Taylor 71 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 13 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.1K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 83 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…Amrita_Pritam_Nayak 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…
-
Looking for query to fatch the specific security profileSummary: Content (required): Hi Expert, We are looking for a SQL query to get the list of roles that are attached with a specific security profile like a document securi… -
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 65 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …Naved Khan 746 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM