Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Function to format Exponential value to number
Summary:
Hi ,
I getting output in exponential value but i need in number. I have used to_number function as well. Still i am getting exponential value.
Value which i am expecting is :
Formula which i have used:
/* Intialize the variables */
L_DATA_TYPE = 'NUMBER'
L_DEFAULT_VALUE = 0
l_asg_id = 0
l_asg_id = get_context(PERSON_ID, -1)
l_hr_asg_id = to_char(l_asg_id)
l_Fixed_Pay = GET_VALUE_SET('Current Annual Base Salary','|=E_PER_ID='''||l_hr_asg_id||'''')
p_fixed = '#'||l_Fixed_Pay||'#'
If (p_fixed = '##') THEN
Tagged:
0