Oracle Agile PLM tables

Hi Team,

This is with reference to Oracle Agile PLM Module.

There are some project templates have been defined by PMO team in oracle plm application .

Template hierarchy has been defined as per the following structure for the product development

Projects -> Phases -> tasks 

I am unable to find in oracle PLM tables , the meta data /master data/phases/task data which they have defined from front end.

Can you please help me in which table does this master data get stored ?

Thank you for your quick support!!

Add Comment
2 Answer(s)

Well i don’t have real data to play around with but based on what i have worked earlier on, all the Projects related information is stored in Activity table.

Activity table id has few important column called Name,Activity_Number and Parent_ID. Generally when Parent_ID is null that’s project and you can find out the phase/tasks by querying that table and giving Project id as Parent_Id.


Agile Angel Answered on June 25, 2018.
Add Comment

Arif is correct in that the base table is ACTIVITY. Note that there is an attribute called TEMPLATE in the ACTIVITY table that denotes which records are for project templates versus real projects (0=No, 1=Yes, 2=Proposed).

Agile Angel Answered on June 27, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.