upgraded clarity from version 12.04 to 13.3 problem with portfolio tables - unsolved!!

[Anon Anon]

we have multiple queries that stopped working due to the changes made in the database regarding the portfolio tables. We now are struggeling to find all the info (fields) in the new structure.

 

one of our problems is; we don't know where to locate the field pfm_portfolios.bdgt_cst_total in the following query:

 

SELECT DISTINCT u.unique_name AS kpl,
  (pf.bdgt_cst_total) PFBUDGET
FROM (prj_obs_associations a
RIGHT JOIN prj_obs_units u
ON a.unit_id = u.ID)
INNER JOIN prj_obs_types t
ON u.type_id = t.ID
INNER JOIN inv_investments p
ON a.record_id = p.ID
INNER JOIN pfm_Investments pfc
ON p.id = pfc.investment_id
INNER JOIN pfm_portfolios pf
ON pfc.PORTFOLIO_ID = pf.ID
WHERE t.unique_name = 'obs_m_sth'
AND a.table_name = 'SRM_PROJECTS'
AND pfc.ODF_OBJECT_CODE = 'project'
AND TO_CHAR (pf.start_date, 'YYYY') = TO_CHAR (SYSDATE, 'YYYY');

 

can you help us?

[Suman Pramanik]

Hi Pega5u5,

 

Please have a look at the link

 

https://support.ca.com/cadocs/0/CA%20Clarity%20PPM%2013%202%2000%20%20On%20Premise%20-TRK/Bookshelf_Files/HTML/xog/index.htm?toc.htm?1387015.html

 

For example pfm_portfolios.bdgt_cst_total  will map to CAP_SCENARIOS.BDGT_CST_TOTAL

 

Hope this helps.

 

Regards

Suman Pramanik

[Anon Anon]

but then, how do you join the PFM_Portfolio table to this CAP_SCENARIO table?

 

also the link you provided, talks about xog. and i'm missing the link to the portfolio tables.