How to setup an Advanced Condition to compare two fields from Properties list? (Doc ID 1936781.1)

Last updated on JULY 13, 2023

Applies to:

Goal

How to setup an Advanced Condition to compare one field with another field from Properties tree list, without using customer SQL?

For instance, checking if the Action Item Due Date is less than the Open Date. When selecting the Action Item Due Date from Properties list, the Field box is populated with the property label, but when typing in Action Item Open Date in the Value field, it throws an error "The date you have entered is not valid. Please enter a valid date."

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.