2642
Points
Questions
19
Answers
200
-
- 1967 views
- 3 answers
- 0 votes
-
- 1750 views
- 2 answers
- 0 votes
-
- 1973 views
- 2 answers
- 0 votes
-
Hi Dinesh ,
Much depends on what is your exact requirement.
Get Project Details :
Select * from activity where name like ‘Your Project Name’Get Task Details of Project :
Select * from Activity where ROOT_ID IN (Select ID from Activity where name = ‘Your Project Name’);Get dependency details of Tasks of the Project
Select * from activity_dependency where from_Id in (Select id from Activity where ROOT_ID IN (Select ID from Activity where name = ‘Your Project Name));You can use this query to find out the details of Tasks and it’s dependency for a given project
Select ad.from_id,ad.to_id,a1.name pre ,a2.name Tasks,a2.*
from activity_dependency ad, activity a1,activity a2,activity am
where 1=1
AND am.name = ‘your project name’
and a2.root_id =am.id
and a1.id = ad.from_id
and a2.id = ad.to_id(+);Regards,
Arif- 1955 views
- 2 answers
- 0 votes
-
- 2691 views
- 2 answers
- 0 votes
-
Hi Anandh,
We are using 9.3.3. version of Agile. Generally for any PPM object be it Task or Gate if you take your mouse and hover over the particular task or get you will see an option called “Quick View” . Quick view is an OOTB feature provided by Oracle. Once you click on that you will see an option to edit the percentage complete and you can updated it with any numerals starting from 1 to 100. The only precaution you need to take is you are not entering any decimal value.
Post update you can refresh your project to see the updated values. Many times user see that option but when they go to edit they see that field locked/uneditable so u need to have the right privilege in that case.
From action menu when you change the task to In-Process or Complete the percentage task gets update to 50% and 100% respectively.
Regards,
Arif- 2070 views
- 5 answers
- 0 votes
-
1. We created a Criteria
2. Assigned it to Modify privilege
3. Modify Privilege: Apply To : “Programs.General Info.Lock User” and “Programs.General Info.Locked from Program”
4. Assigned to Role.It worked.
This answer accepted by Arif. on April 28, 2024 Earned 15 points.
- 2132 views
- 1 answers
- 0 votes
-
Quality Administrator – Quality change request (QCRs): corrective and preventive actions (CAPAs) and audits
Quality Analyst – Product service requests (PSRs): problem reports and nonconformance reports (NCRs)This answer accepted by Divakar. on April 28, 2024 Earned 15 points.
- 2303 views
- 3 answers
- 0 votes
-
- 2303 views
- 3 answers
- 0 votes
-
- 2719 views
- 3 answers
- 0 votes