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

    • Integer Field Comparison in Validation Rules Not Working as Expected

    in Field Service 2 comments

    Hi Oracle Community,

    I’ve created two custom properties in Oracle Field Service: activity.XX_INT1 and activity.XX_INT2, both set to Integer type.

    In the validation rule for XX_INT2, I’m checking that its value is greater than XX_INT1 using:

    this > activity.XX_INT1

    What’s happening:

    This doesn’t behave as expected. For example, with XX_INT1 = 46:

    • Entering 1, 2, 3 → validation fails (expected)
    • Entering 5, 6 → validation passes (but 5 is less than 46)
    • Entering 111, 123 → validation fails (but 111 is greater than 46)

    However, if I write the condition like:

    this > 46

    …it works exactly as expected.

    Question:
    Is there a supported way to perform true numeric comparison between two Integer-type fields in OFS validation rules?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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