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!!
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.
Regards,
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).