All posts on Sample SQL Queries
Do you know how to get the list of balances without any feeds tagged to them? What will happen if there are empty balance definitions and the dimensions are being referenced in formulas/reports? Read on to know more details.
Do you know how to fetch the Payroll Run Results with all input values for elements processed? Read on to know more details.
Do you know how to fetch the Positions without costing information? Read on to know more details.
Do you know how many users are logged in to the system today? Do you see any suspicious activity going on in the system and want to audit the users who are logged in today? Read on to know more details.
Do you know how to identify the Delegation of Roles and Approvals setup by Employees and who is the serving as proxy for whom? Read on to know more details.
Do you know how to fetch the Grade Ladder details and Grades that are added to Grade Ladder? Read on to know more details.
Do you know how to fetch the Grade Rates from backend tables? Read on to know more details.
Do you know how to get the Flow Instance Name from the Payroll Action ID? From BI Report History we can get the Payroll Action ID for all HCM Extract related reports and Payroll Processes like Pay Check, EFT and Payslips etc. Read on to know more details.
Do you know how to get the element definition load errors? How to resolve the issues? Read on to know more details.
Do you know how to extract the HCM Extract errors? Where would you check the errors of the extract on the application? Read on to know more details.