How to use distinct in Value set in Oracle Apps

Value sets in Oracle Apps

Solution 1:

Either you create a View and use it in place of table in value set. You can create your query with distinct values in the view and later use it in value set.

CREATE OR REPLACE VIEW CUST_EXAMPLE

AS

   SELECT DISTINCT EMPLOYEE_NUMBER

              FROM PER_PEOPLE_F PPF

             WHERE SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE

                               AND PPF.EFFECTIVE_END_DATE;

Solution 2:

You can directly use query in place of table name in Value set.

(SELECT DISTINCT EMPLOYEE_NUMBER

              FROM PER_PEOPLE_F PPF

             WHERE SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE

                               AND PPF.EFFECTIVE_END_DATE) ab

Kindly provide your feedback.

Have a nice day :)