In this article I will guide you through the most frequently used SQL Queries in Fusion HCM and also some of the advanced concepts in SQL Query that you can achieve in Fusion HCM.
Links for SQL Queries:
- How to get the count of data loaded using HDL for business objects?
- How do we extract the Grade Ladder step rates?
- How to find the Lookup Type for an attribute that supports HDL load?
- How to modify the reports/value sets for Payroll table changes in 24A?
- PI Cube – FREE SQL Developer-like tool for Oracle Cloud
- How to fetch Balance Initialization and Adjustments for employees?
- How to fetch Payroll Run Results when employees have multiple assignments?
- How do we extract the Payslip Information for DOR tables?
- How to customize the Check print report in Payroll?
- How to get the Lookup codes for a specific country and exclude the country if it’s excluded?
- How to fetch Balances without any feeds?
- How to fetch Payroll Run Results with all input values for elements?
- How to fetch Positions without Costing Information?
- How to fetch the current logged-in Users list?
- How to fetch the Delegated or Proxy Users?
- How to fetch Grade Ladder details and Grades in Ladder?
- How to extract Grade Rate details from backend tables?
- How to get the Flow Instance Name using Payroll Action ID from BI History?
- How to fetch Element Definition load errors using SQL Query?
- How to query the HCM Extract Errors?
- How to get the count of data loaded from multiple tables post-data conversion?
- How to get the Audit History of the changes done by a user?
- How to get list of Fast Formulas used in HCM Extract?
- How to extract the Sandbox, features enabled, and published status?
- How to fetch the Employee Degrees from the Skills and Qualifications screen?
- How to check the Approval Rule status using BI Report?
- How to get Dynamic Default for Payroll Period LOV based on the system date?
- How to extract the Element Eligibility Info from Element Config?
- How to fetch the Employee Social Insurance Calculation Card details for AE legislation?
- How to get the list of all BI Reports from an instance?
- SQL Query to fetch Costing of Payroll information
- SQL Query to fetch Costing of Persons information
- SQL query to fetch Position Costing information
- How to bulk inactivate the Document Types using HDL?
- SQL query to pull Time cards that are not approved status
- SQL query to pull the EEO Information
- SQL query to pull Absence Accruals not run as of input date
- SQL Query to pull the HDL Loaded and Error Records
- SQL Query to extract Absence Plan Configuration
- How to fetch Pension Automatic Enrollment Calculation Card Info for UK Legislation?
- How to update the Final Close Date FINC on Assigned Payroll?
- How to find special characters in a column?
- How to load and delete AssignedPayroll information using HDL?
- How to pull UK Calculation Card Info?
- How to fetch the Address formats and Installed Legislations?
- How to fetch Third Pary and Third Party Payees?
- How to extract document types for all legislations?
- How to attach Requisition Templates to Positions in bulk?
- How to fetch Enterprise HCM Information?
- How to retrieve Payroll balance Initialization Errors?
- How to pull Time Card Required and Overriding Period Details?
- How to load Position Costing using HDL?
- How to fetch US Calculation Card Association Details?
- How to fetch employees with Gross Earnings and Net Pay in a defined range?
- How to fetch Person Security Profile Config info?
- How to fetch the data role and attached security profiles?
- How to extract the Prescreening Questions and Answers filled in by the Candidate?
- How to get the Offerings and Opt-In features in Cloud applications?
- How to get the Employees Processed by Payroll Processes?
- How to extract the list of Alerts from Alert Composer?
- How to fetch data from Tax Credit Information Calculation Card for Canada Legislation?
- How to load Performance Rating and Career Potential using HDL in Talent Profiles?
- How to modify the Person Number after hiring the employee?
- How to fetch the Tax Reporting Unit info from the Calculation Card?
- How to Migrate the Role Mappings from one instance to another using HDL?
- How to find assignments without calculation card associations?
- How to delete Calculation Cards using HDL?
- How to extract the City, County, State, Zip Combination Geo Codes from Vertex?
- SQL Query to extract Element Configuration Information
- SQL Query to extract Eligibility Profiles and the Eligibility Criteria
- SQL Query to fetch Absence Plan Configuration
- SQL Query to fetch Delivery Option details for HCM Extracts
- SQL Query to find the mapping between Business Unit and Reference Data Set
- SQL Query to fetch the Learner Course Progress Report
- SQL query to fetch Payslip and W-2 delivery preferences
- SQL Query to fetch employees with missing bank account
- SQL Query to fetch Assignment Level Element Entries
- How to use the Sensitive Data Access Audit feature from 21B?
- How to find the HCM Groups assigned to Employees?
- SQL Query to fetch Benefit Life Events processed for employees
- Do you know how to query the payroll flow tables to get the payslips generated count?
- SQL Query to fetch HCM Data Loader Load Summary
- SQL Query to fetch Data Roles and Security Profiles
- SQL Query to fetch Pending Job Requisitions
- SQL Query to fetch Fast Formulas used in HCM Extract
- SQL Query to fetch Recruiting Location Hierarchy
- SQL Query to fetch Requisition attachment details
- SQL Query to get Element Costing Information
- How to pull the Payroll Elements Listing Report using SQL Query?
- How to find the contexts required for a Payroll Balance and Dimension
- SQL Query to get the User status and assignment information
- SQL Query to pull Legal Employer and Enterprise Hire Dates
- SQL Query to pull Assigned Payrolls Information
- How to resolve column splitting into multiple rows issue in BI Publisher?
- SQL Query to get the Payroll Definition Config Information
- SQL Query to find Worker Count by Person Type
- How to refer candidates in ORC and track them?
- How to fetch the flattened Supervisor Hierarchy for employees using SQL Query?
- How to translate BI Report Output to other languages?
- SQL Query to identify person relationship with Organization
- How to Mask Work Email Address in Dev or Test instance post P2T Refresh
- How to Reverse Terminate employees using HDL?
- SQL Query to fetch ORC Candidate Job Application Status
- How to Export Jobs from one POD to another using HDL?
- SQL Query to get Unique and Active Line Managers Names
- Sample Table Valuesets for ready reference
- Personal Payment Method, its importance and query for Active Employees
- SQL Query to pull the Payroll Balance Feeds
- SQL Query to get the Payroll Name, Time Card Required Flag from Payroll Relationship Screen
- SQL Query to get the modified fields from the Assignment table using Audit functionality
- How to Create BI Report using static Excel file .xls
- How to Create BI Report using static CSV file
- SQL Query to get the Object Group Employees
- How to use Regular Expressions in SQL Query?
- How to Resolve issues with User-Level Report Timezone on BI Report?
- How to generate CSV output from BI Reports/HCM Extracts?
- Oracle HCM Cloud Data Dictionary Tables
- Query for Rehire Recommendation Flag
- Deriving Values for DFF segments based on other fields
- What is the alternative for DATA_CACHE which is being deprecated from 21A?
- How to get the LDG associated with Legal entity?
- How to deal with Datetimes stored in Database as UTC timezone?
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Automated Parallel Processing technique for BI Report
- Security Matrix with User and Role Mappings
- SQL Queries to pull Action Type, Action, Action Reason and Action Reason Usages
- SQL query to pull Work Schedules for Assignments/Legal Employers
- SQL Query to get the Flattened User Defined Table (UDT) Information
- Areas of Responsibility (AOR), Its usage, Data Load and Report
- SQL Query to get the Dropped Dependents from Benefits Coverage
- Assignment tables PER_ALL_ASSIGNMENTS_M and _F differences
- SQL Query to fetch Bank, Branches and External Bank Accounts
- Passing Logged in User details to HCM Extract
- SQL Query to find changes within a specific timeframe
- SQL Query to find the Position Incumbents
- Running the latest extract version using Payroll Flow
- SQL Query to find pending approval transactions from Workflow tables
- SQL Query to fetch Descriptive Flexfield information from an instance
- Bypass the FROM Clause limit in Table based Valueset
- Get the info of Attachments loaded to UCM
- List of functions available in per_extract_utility package
- SQL Query to fetch the Document of Records
- SQL Query to fetch Cancelled Work Relationship and Reverse Termination
- Difference between PER_ALL_ASSIGNMENTS_M and _F tables
- SQL Query to get Payroll Element Entries
- SQL Query to get Position and Job Valid Grades
- Dynamic Output and Bursting for BI Report
- SQL Query to get Scheduled Process Job History
- SQL Query to get the Time in Job and Position
- Display Person Image on BI Report
- Introduction to User Defined Table (UDT) in Fusion HCM
- Using Aggregate functions in Table based Valueset
- Resolving Assignment Name and Job Name not in sync issue
- SQL Query to fetch employee person and assignment info
- SQL Query to fetch Supervisor Direct and Indirect reportees
- Using Role Mappings and Auto-provisioning Rules
- SQL Query to get Source System IDs for all Business Objects
- Using Table based Valueset when DBI is unavailable
- How to get Position Hierarchy in SQL Query?
- Skip Output file of HCM Extract when no data is fetched
- Configuring Payroll Process Configuration Groups
- Cancel an existing Work Relationship using HDL for employees
- SQL Query to get the Valueset and Lookup Values
- List of tables which are impacted by Scheduled Processes
- How to get the Payroll Balance details in BI Report?
- Most frequently used Date, Number and String functions
- Most Frequently Used SQLs for List of Values (LOVs)
- SQL Query to get Fast Formula and related info
- SQL Query to get Geography Information
- SQL Query to get Supervisor Change HDL for Assignment
- SQL Query to get User last login information
- SQL Query to get the HDL file from staging tables
- Basics of Valuesets in Fusion HCM
- SQL Query to fetch Flattened Organization Hierarchy Tree
- Table Naming Convention in Fusion Applications
- Using Session Variables in BI Reports to get logged in user info
- Execute Reports from Navigator without exposing the BI Catalog
- SQL to fetch 200+ rows – Direct Database Query – Obsolete
- Security Matrix Users and their Roles
- Most frequently used Tables list in Fusion HCM
- Mapping of fields on Application pages to Lookup Codes
