E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Round Function is not working and is impacting Payroll

S.PrasadSep 15 2022

Hi ,
We are trying to use the ROUND function in following code in a E-text template but it's not working with DIV .
Can anyone suggest on this !

IF(Salary_Frequency = 'Weekly')THEN
(
IF(Payroll_Frequency IS NOT NULL)THEN
(REPLACE((IF(Payroll_Frequency = ’Weekly’)THEN(Substr(Payroll_Runs,instr(Payroll_Runs,’|’,1,1)+1)*Normal_Working_Hours*(Assignment_Salary DIV Normal_Working_Hours))
ELSE IF(Payroll_Frequency = ’Biweekly’)THEN (Substr(Payroll_Runs,instr(Payroll_Runs,’|’,1,1)+1)*Normal_Working_Hours*2*(Assignment_Salary DIV Normal_Working_Hours)) ),’.’,’’))
END IF
)
END IF

Please let me to if you need any information from my end.
Thanks in advanced .

Added on Sep 15 2022

#human-capital-management-hcm, #human-resource-management-hrms

0 comments

50 views