Fast Formula

Requirements: Requirement is that write Fast Formula that can display leave days 25 if employee service is 5 or more else leave days 20 for other employee (less than 5 years’ service)

STEPS: 1) Fast Formula Creation:

First we need to create a fast formula and compile it for the requirement ***************************************************************************** FORMULA NAME: Service_Leave

FORMULA TYPE: Global Absence Accrual

DESCRIPTION: Returns 25 days if service >= 5 years, else 20, based on dynamic employee data. ***************************************************************************** */ DEFAULT FOR PER_REL_ORIGINAL_DATE_OF_HIRE IS '4712/12/31 00:00:00'(date)

DEFAULT FOR PER_ASG_FTE IS 1

ld_hire_date = PER_REL_ORIGINAL_DATE_OF_HIRE

ld_effective_date = GET_CONTEXT(EFFECTIVE_DATE, '4712/12/31 00:00:00'(date))

ln_fte = PER_ASG_FTE

ln_service_years = FLOOR(MONTHS_BETWEEN(ld_effective_date, ld_hire_date) / 12)

IF (ln_service_years >= 5) THEN (

 accrual = 25 * ln_fte

) ELSE (

 accrual = 20 * ln_fte

)

ceiling = 60

carryover = 15

RETURN accrual, ceiling, carryover

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.

3) Assigning Absence Plan “LeaveTest” to An Existing Employee: To test this fast formula, I am assigning it to two employees but I will show the process that how can we assign this plan to an single employee and for other employees it is same procedure. Here I have taken one of the dummy employee “Mohsin Ali”. Navigation: Springboard à My Client Group à Absences à Absence Records à Search for An Employee (Click Advance Search after writing employee name) and find employee from list” à See Plan Participation and Click Enrollment and Adjustment and Click add Enrollment and then select plan as “LeaveTest” or whatever you have created.

A screenshot of a computer

AI-generated content may be incorrect.

Note: See in description above that after clicking add enrollment then select plan and click submit and now we are done for this page. In step 3, Balance for you will be zero because it is necessary to perform Calculate Accruals and Balances then come back to step 3 again to see changes means do step 1 to 3 and then step 4 as Calculate Accruals and Balances and then again navigate back to step 3 to see changes. 4) Calculate Accruals and Balances Navigation à Springboard à Tools àScheduled Processes à Click Schedule New Process and Search for Calculate Accruals and Balances and then click ok and new pop up will appear which we need to configure as below and then submit it

A screenshot of a computer screen

AI-generated content may be incorrect.

 

 

 

 

 

 

 

 

 

 

 


A screenshot of a computer

AI-generated content may be incorrect.

 

Note: Here Provide Business Unit,Legal Employer and Legislative Fields that are assigned to this person and, other fields if you have any value and then click submit and click refresh until status shows successful. 5) Verify the Record: Until now it is done and now I need to see if data is shown for this person. Navigation: My Client Group à Person Management à Search with Employment Number whom you have assigned this absence plan as we have assigned to Mohsin Ali and then click three … to view and find absence balance from it and see result is as below or check like in step3.

A screenshot of a computer

AI-generated content may be incorrect.

 

Comments

Popular posts from this blog

Importance of Incremental Data in Oracle Fusion

Mastering Parameters in Oracle Fusion BI Publisher

REST Web Service in Oracle Fusion to manage Banks