SQL
Discussion List
-
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 624 views 5 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 91 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 201 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 383 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM
-
Scheduling in HCM ExtractWe have the following requirement for the extract and would like to seek inputs on feasibility and the recommended solution approach. Requirement: The extract XX needs t…
-
How to bring the value from Previous schedule in HCM ExtractTeam, We have scheduled an extract where the Union Name parameter has a default constant value of CUPE. During the first scheduled run, we manually selected NBUPPE. Howe…
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
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 2 views 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 17 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 5 views 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 24 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 173 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 641 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 640 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 2 views 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 142 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 513 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 700 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 575 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 89 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