Dec 12, 20221 min readSQL query to Get the Payroll Frequency and Name of any EmployeeBelow query will give the Employee details with the Payroll Relationship details assigned to them. SELECT peo.PERSON_NUMBER,...
Oct 15, 20201 min readQuery to get element input values sum for already approved or approval pending entries This was an interesting requirement where we need to find out the sum of input values for the particular month as particular element was mul
Jun 16, 20201 min readPayroll Elements - Questionnaire based HDL Template - HCM Based on the data filled in questionnaire application automatically creates supporting elements in addition to the element we create, appli
Jun 14, 20201 min readQuestionnaire HDL sample file for Payroll Elements - HCM PayrollElement classification - Standard Earning. Questionnaire Excel file Questionnaire HDL (.dat) file Element classification - Supplement...
Jun 12, 20201 min readSQL query to get DBI Contexts & back end query - HCMWhile writing Fast Formula in HCM we consume DBIs often. There are cases where we need to see the logic behind the DBI, what are the contex
Jun 11, 20201 min readCompile Fast Formula in bulk - HCMMigrating Fast Formulas to other pods after could be cumbersome process, we can migrate all custom Fast Formulas created and compile them in