AnsweredAssumed Answered

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

Question asked by Pega5u5 on Jul 20, 2015
Latest reply on Jul 27, 2015 by Pega5u5

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?

Outcomes