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

    How to convert a text UDF to a number for use in a calculation

    edited Dec 13, 2022 7:02AM in Taleo Enterprise 3 comments

    Summary

    We have a UDF to capture the Commission amount and a UDF to capture the Total Target Comp for Sales offers. I want to calculate the commision split in OBI but it see the field as a text field.

    Content

    I used the CAST function to attempt to convert the UDF to a number using CAST("Submission Job Offer Flex Fields"."UDF19" AS INTEGER).  OBI accepts the formula but i am unable to use it to calculate the split so it doesn't seem to being seeing it as a number after all.  Any help would be greatly appreciated.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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