SQL Query to get the Dropped Dependents from Benefits Coverage
Do you know how to create the BI Report to get the Dropped Dependents from Benefits Coverage? Read on to know more details.
All posts on Sample SQL Queries
Assignment tables PER_ALL_ASSIGNMENTS_M and _F differences
Do you know which table to use while building query on assignment information? PER_ALL_ASSIGNMENTS_M or PER_ALL_ASSIGNMENTS_F or PER_ALL_ASSIGNMENTS_M_? Read on to know more details.
SQL Query to fetch Bank, Branches and External Bank Accounts
Do you know how to extract the Banks, Bank Branches and External Bank Accounts? Read on to know more details.
Passing Logged in User details to HCM Extract
Do you know that you can get the Logged In User details in HCM Extract? Why the seeded functions which return user details in BIP does not work in advanced filter directly? Read on to know more details.
SQL Query to find changes within a specific timeframe
List of Functions to convert date to a different timezone and use them in SQL Query to get the required information. Read on to know more details.
SQL Query to find the Position Incumbents
Do you know how to build query to find out the Position Incumbents? Position Incumbents are nothing but the employees hired into the Position. Read on to know more details.
Running the latest extract version using Payroll Flow
Have you faced issues with multiple versions of extracts? How do you migrate the extract changes to other instances when the target instance already has the extract? Read on to know more details.
SQL Query to find pending approval transactions from Workflow tables
Have you used the approval related tables to fetch the In Progress/Approved/Withdrawn transactions? Can you do another transaction on the business object which has an in process approval? Read on to know more details.
SQL Query to fetch Descriptive Flexfield information from an instance
Do you know how to fetch the configured Descriptive Flexfields from an instance? Do you know in which table and attribute the data resides?
Bypass the FROM Clause limit in Table based Valueset
Do you know that you can bypass the FROM Clause character limit of 240 in table based valueset using a workaround? Read on to know more details.