AnsweredAssumed Answered

Difference between both the ways of Program to Project association.

Question asked by rahul.agrawal03 on Jun 23, 2011
Latest reply on Jul 4, 2011 by navzjoshi00
What are the differences (if any) in the below two scenario of Program-Project Association:

1. Go to Program-> Subproject tab and associate the child project.
2. Go to Child Project -> Hierarchy -> Parent and then associate the Parent Program

I have a BEFORE trigger on PRSUBPROJECT which runs fine in the first case but NOT in second (in the second case it is not able to find data for this qry which is in Trigger -
SELECT prprojectid into parent_id FROM prtask WHERE prid = :New.prtaskid ). In first case this query works fine.

I took SQLtrace also to find out some difference but both traces looks almost same. A new row gets inserted first in PRTASK before inserted to PRSUBPROJECT. Hence, this trigger should be fine for both the above cases.

Would like to know any technical differences between above two ways of association.

Thanks,
Rahul

Outcomes