SQL
Discussion List
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 1 view 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
How to pass person id from redwood page to Value setSummary: How to pass person id from redwood page to Value set Content (please ensure you mask any confidential information): Hi all, We created a value set to fetch late…MSQamar 11 views 5 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed… -
sql to fetch payroll process having ui_task_status = 'COR_FLOWS'Summary: Parameter having p_start_date , p_end_date, p_payroll_name based on this parameter will identify period name and start_date and end_date from pay_period table. …Ankush Jadhav -Oracle 1 view 0 comments 0 points Most recent by Ankush Jadhav -Oracle Reporting and Analytics for HCM -
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b…Consultant Ian 31 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…usr_a.nv 171 views 19 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …User_2025-01-30-23-59-27-880 1.7K views 12 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM -
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 682 views 5 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 641 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query optimization for HCM audit report with UNION ALL + UNPIVOT - need hints/index strategySummary: My audit trail query (HCM objects with UNION ALL for 30+ audit tables) was taking 12 minutes with left join on tables per_all_assignments_m and per_all_people_f…Vishal Purohit 1 view 0 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
How do I link fa_fusion_soainfra.wftask with HRA_EVAL_STEPS?We have evaluation steps where users go through workflow tasks. I have the evaluation steps and the comments from the workflow tasks. I am unable to find suitable column…
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 139 views 6 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …Opkey PA 521 views 6 comments 0 points Most recent by Sammeta Srividya Reporting and Analytics for HCM
-
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…User_2025-01-30-17-58-41-867 726 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several …
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 571 views 10 comments 0 points Most recent by Parag Hiremath 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 1.3K views 6 comments 0 points Most recent by Dai Huynh Minh Reporting and Analytics for HCM -
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T… -
Participant Feedback Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi…
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 92 views 2 comments 0 points Most recent by Eric-Oracle Reporting and Analytics for HCM
-
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): …Helen Thomas 41 views 13 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
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 161 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 131 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 161 views 2 comments 2 points Most recent by SankarBalu Reporting and Analytics for SCM