Issue with rounding need to cancel it
R12.1.3
Hello Folks,
I have a rounding issue with Custom SIT (Overtime Request) with segment which required
and have sql statement as below
SELECT ROUND(ROUND(:$FLEX$.XX_GROSS_SAL_V6 / 30,2)/8,2) FROM DUAL
And value set with type number and precision 2
And I change it to be
SELECT TRUNC(:$FLEX$.XX_GROSS_SAL_V6 / 30)/8),5) FROM DUAL
And change the value set to be number too and precision 5
But it don’t work and show error that this required field don’t have value
(Segment required but calculated automatically not entered by the user)
And inputs folks?
Thanks