SQL
Discussion List
-
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu…Valerio Curzi 71 views 6 comments 0 points Most recent by Ashraya S.N 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… -
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 961 views 13 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 11 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM -
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 496 views 9 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage…Steph96 138 views 3 comments 0 points Most recent by Matheus Roberto Reporting and Analytics for HCM -
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
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 >…
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…Alpesh Sanghvi 2 views 0 comments 0 points Started by Alpesh Sanghvi Reporting and Analytics for HCM
-
In Oracle Fusion TEST, Profile Codes shown in front end but not in HRT_PROFILES_B table.Summary: In oracle fusion TEST instance, am able to see the Profile Codes for Talent Profiles in front end, but am not able to see it in HRT_PROFILES_B Table. Whereas I …Gopika Prem Kumar 11 views 0 comments 0 points Started by Gopika Prem Kumar Reporting and Analytics for HCM
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid…Matheus Roberto 22 views 0 comments 1 point Started by Matheus Roberto Reporting and Analytics for HCM -
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…ShawShankk 2.3K views 5 comments 0 points Most recent by Vikas.puppala Reporting and Analytics for HCM
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 24 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
SQL query to retrieve the approval history dataSummary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval' Content (please ensure…Sonia V 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Position Hierarchy queryHi, I need a small query that returns parent position name and code of positions. Is it possible for you to share the query about it? Regards -
Trace the processing details of scheduled BIP ReportSummary: Trace the processing details of scheduled BIP Report Content (please ensure you mask any confidential information): Hi Team, Greetings! What are the best option…Parag Hiremath 26 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
HCM Quick Link Usage StatisticsSummary: Looking for statistics for individual pages access by role, user, etc… for a specific timeframe Content (please ensure you mask any confidential information): A…
-
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… -
How to Extract More Details from Oracle Access Logs (Failed Logins)Hello, We are currently trying to understand if there is a way to extract more detailed information from the Oracle access logs. At the moment, we are only able to extra…Rebecca Bortone 21 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co…LTalbott2 21 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Help desk query FAQ accesses countHello Experts I need to acquire information from Help desks FAQs in HCM More precisely: * Name, info, last update, etc And the best after this would be to discover how m… -
Trying to get BIP report to burst and consolidate on emailSummary: I am having trouble getting my BIP report to burst and consolidate delivery by email, even though the Enable Consolidate Output box is checked. I have been doin…
-
How to build query like audit report?Summary: Content (please ensure you mask any confidential information): I can run this Audit Report: Is it possible to query the database to obtain the same info? Versio…Stefano_Mazzocca 12 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM -
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks…Valerio Curzi 21 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Duplicate and Missing Payroll Payment Records for EmployeesContent (please ensure you mask any confidential information): I'm encountering an issue where the query returns two rows for a person one with the correct payment statu…User_VQ154 26 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can…Reddykrishna Chidella-Oracle 86 views 4 comments 1 point Most recent by Soumya Suravita Reporting and Analytics for HCM