SQL
Discussion List
-
Users Record History in fusion HCMSummary Users Record History in fusion HCMContent Hi Everyone, Do we have any diagnostics report where we can get user records history ,complete changes happened on user… -
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >…
-
MilanMohanty 153 views 3 comments 0 points Most recent by Mohd Affan Ahmed Reporting and Analytics for HCM -
Query optimization questionSummary: Processing is fast only when not filtering by wlf_assignment_records_f.COMPLETION_DATE Content (please ensure you mask any confidential information): I have a l…Stefano_Mazzocca 31 views 6 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 133 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query for HDL to purge DOR of terminated employees .I am looking for a report that generates HDL to purge /Archive DOR for terminated employees from certain date range .
-
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25DSuresh Kannan Saminathan 117 views 2 comments 2 points Most recent by SankarBalu Reporting and Analytics for SCM -
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
How to use attachment tab in datamodelHi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c…Nivya Mathire 1 view 0 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Is there a way to get attachment attached to questionnaire responseSummary: We need to fetch the attachment which is attached as response to a question. These questions are enabled under guided journeys. Please advise if we have any of …
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Multiple Absence Actions Sharing the Same Object IDThere was an error rendering this rich post.
-
How can I determine which weekday corresponds to DAY_START_NUM and DAY_STOP_NUM(ZMM_SR_PATTERN_DTLS)Hi everyone, I have a question regarding the ZMM_SR_PATTERN_DTLS table, specifically the DAY_START_NUM and DAY_STOP_NUM columns. In my case, I have: DAY_START_NUM = 1 DA…Andriampeno Odilon 11 views 1 comment 0 points Most recent by Andriampeno Odilon Reporting and Analytics for SCM -
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.6K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
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…User_2025-01-23-21-24-21-434 117 views 5 comments 0 points Most recent by Jagdish Kolli Reporting and Analytics for HCM -
How can I retrieve the full details of each exception?Hi everyone, I’m working on a report that returns schedule exceptions using the following query: SELECT 1 KEY, pse.SCHEDULE_EXCEPTION_ID, pse.SCHEDULE_ID, pse.SCHEDULE_A…Andriampeno Odilon 35 views 4 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM
-
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 56 views 3 comments 1 point Most recent by R Ravichandran Reporting and Analytics for HCM
-
SQL runs in query tool but not Data ModelI need to calculate the number of days a person will work during a pay period. To do this I am calculating the the days from the last day of work through the end of the …Jason Snipes 14 views 6 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple AssignmentsHi Navigation: Calculation Cards > Benefits and Pensions I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report. If not…Nilesh D Patel 106 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI)
-
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…
-
Tables lock or obsolete statisticsSummary: Hello experts! It's possibile to verify if it's present a lock on a table o the statistics are obsolete? We have a BI query of a scheduled job that times out ra…Gian Luca Triglia 2 views 2 comments 1 point Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration
-
SQL query to retrieve additional manager types at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve hierarchies loaded in core hr for additional manager types (no…Valerio Curzi 12 views 1 comment 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu… -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe…C.R.Balaji 15.9K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 752 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Query to get Statement of Earnings (Payroll> Person Results> Calculate Payroll> Standard Earning.)Summary: Could anyone please provide a query to retrieve the following data? Query to get Statement of Earnings (Payroll> Person Results> Calculate Payroll> Statement of…Choudhary Punit 30 views 0 comments 0 points Most recent by Choudhary Punit Reporting and Analytics for HCM -
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a…