Total Visits: 11
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:
- 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
- List of User Entities, DBIs, Routes and Contexts from R13 19D
- 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
- Resolve EDIT button is grayed out on Assignment screen
- 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