CA PPM Tuesday Tip: Which template was a project created or copied from?

Discussion created by Connie_Fu on Jun 17, 2015
Latest reply on Jun 29, 2015 by Robert Ensinger

The table ODF_OBJECT_COPY_FLAT stores the source and destination project's internal IDs and keep a history of each unique combination of the source and destination projects.


Here is a query to identify the internal ID of a template from which a project has been created or copied from. This does not include task copy.


select templ.code copiedFrom, copied.code copiedTo, flat.created_by copiedBy, flat.created_date copiedDate

from odf_object_copy_flat flat, inv_investments templ, inv_investments copied

where flat.src_object_id =

and flat.object_code = 'project'

and flat.object_id =


Example result from a project 'copied1' created from a template 'csk.majorIT', followed by a copy project done from template 'test_template', again from template 'csk.infrastructure', and again from template 'test_template':