This discussion is archived
0 Replies Latest reply: Sep 25, 2009 2:01 PM by 596478 RSS

Can I prevent duplicate values entry thru Forms Personalization

596478 Newbie
Currently Being Moderated
We use Oracle Project. While entering key Members on Project Form, we want to prevent users to enter multiple "Project Accountant" within the same project. So essentially there should be only one "Project Accountant" per project. I have sql for this

SELECT 'X'
FROM PA_PROJECT_PLAYERS
WHERE PROJECT_ID = 11494
AND PROJECT_ROLE_TYPE = '1001'
AND ((START_DATE_ACTIVE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, START_DATE_ACTIVE + 1))
OR (END_DATE_ACTIVE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, END_DATE_ACTIVE + 1))
OR (START_DATE_ACTIVE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, START_DATE_ACTIVE + 1)))
AND (PROJECT_PARTY_ID IS NULL OR PROJECT_PARTY_ID != PROJECT_PARTY_ID) ;

But I am not able to figure out how to put this into Forms Personlization. Can someone help.

Thanks
Rakesh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points