How to create update recurring and STOP formula result together in Oracle Payroll?
The Update recurring entry is used to update the entry input value of the element entry through payroll processing and STOP is used to end-date the element.
There could be a scenario where we want use both in an element.
For e.g. User wants to save the loan deducted till date in one of the input values for easy visibility (at entry level) and also once the loan is completely paid out, the entry should be end-dated automatically.
As per Oracle, below is the way to design the fast formula using these two return types:
Always use the variable for STOP as zz_STOP so that it is the last action performed by the formula. The formula process each return in alphabetic order of the return variables.
For e.g. if we have below return in a formula:
RETURN
a_value1
,c_value_2
,d_value_3
,b_value_4
,v_value_5 → update recurring formula result
,STOP
then the order in which the the formula will process it will be
RETURN
a_value_1
,b_value_4
,c_value_2
,d_value_3r
,STOP
,v_value_5 →update recurring formula result
Always make sure that the STOP variable is processed as the last variable.
If the STOP variable is not the last action, the UPDATING_ACTION_ID column in PAY_ELEMENT_ENTRIES_F will not be updated correctly and this will lead to the error “APP-PAY-07001” while deleting and retrying the payroll.
The correct order of execution of return should be:
RETURN
a_value_1
,b_value_4
,c_value_2
,d_value_3r
,v_value_5 →update recurring formula result
,zz_STOP
Always use ZZ_STOP to variable name for STOP so that is always the last action processed in the RETURN.
For more such posts, please provide your inputs in the comment section