Oracle Agile PLM tables
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.