SQL Query to fetch HCM Data Loader Load Summary
Do you know how to fetch the HCM Data Loader status from backend tables? Does it pull both HDL and HSDL data loads? Read on to know more details.
All posts on BI Publisher
SQL Query to fetch Pending Job Requisitions
Do you know how to fetch the Job Requisitions which are waiting to be approved? Can we get the info on where exactly the approval is struck? Read on to know more details.
SQL Query to fetch Fast Formulas used in HCM Extract
Do you know if there is a way to get the list of all fast formulas that were used in a HCM Extract? It will be a life saver when there is a need to migrate the HCM Extract to target instances. Read on to know more details
SQL Query to fetch Recruiting Location Hierarchy
Do you know how to fetch the Recruiting Location Hierarchy for ORC? Read on to know more details.
SQL Query to get Element Costing Information
Do you know how to fetch the Element Costing information along with Element Eligibility? Read on to know more details.
How to pull the Payroll Elements Listing Report using SQL Query?
Do you know how to pull the Element Configuration from Fusion Application? Want to know whether the element is recurring/Non-Recurring, Classification, Level at which the element can be assigned? Read on to know more details.
How to find the contexts required for a Payroll Balance and Dimension
Do you know how to find the contexts required to fetch a payroll balance dimension? Read on to know more details.
SQL Query to get the User status and assignment information
Do you know how to get the user status and his/her assignment details? Read on to know more details.
SQL Query to pull Legal Employer and Enterprise Hire Dates
Do you know the importance of Legal Employer and Enterprise Hire dates? How do you pull them using SQL Query? Read on to know more details.
SQL Query to pull Assigned Payrolls Information
Do you know how to load the AssignedPayrolls and extract that information from the HCM system? Read on to know more details.