You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI 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

    edited Nov 6, 2023 9:33AM in Compensation 3 comments

    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:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!