Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query controlling settings defined on a given project in PPM v7.5

SOLVED
Go to solution
Highlighted
dokhelar
Occasional Contributor

SQL query controlling settings defined on a given project in PPM v7.5

My need = SQL query to control the 'Cost and Effort settings' of the projects, specially the settings related to financial management =
flag 'Allow capitalized costs on this project '
flag 'Enable Financial Management for Work Plan'
rule defined for Planned costs
rule defined for Actual labor costs on the work plan
rule for Roll up actual costs from the work plan into the project budget

 

Who knows the Oracle tables where these information are stored and the relations between these tables ?

 François

1 REPLY
dokhelar
Occasional Contributor
Solution

Re: SQL query controlling settings defined on a given project in PPM v7.5

Finally, I have found by myself the answer with a query  based on tables ITG_SETTINGS_CONT_ATTRS and ITG_SETTINGS_ATTRIBUTES

ex: query to control settings related to Financial Management settings =

select p.project_id, b.NAME,  b.VALUE

from PM_PROJECTS p, PM_PROJECT_TYPES pt, ITG_SETTINGS_CONT_ATTRS a, ITG_SETTINGS_ATTRIBUTES b

where p.PROJECT_ID = xxxx

and p.PROJECT_ID = pt.PROJECT_ID

and pt.PT_SETTINGS_KEY =  a.SETTINGS_CONTAINER_ID

and a.SETTINGS_ATTRIBUTE_ID= b.SETTINGS_ATTRIBUTE_ID

and b.name in ('CE.enableFM','CE.isCapitalized','CE.plannedCostAuto','CE.actualCostAuto','CE.rollupCostsToBudget') 

//Add this to "OnDomLoad" event