AnsweredAssumed Answered

Q: Planned Cost Finish - different valude displayed in Clarity / Database ?

Question asked by capgemini.support.1 on Oct 29, 2012
Latest reply on Jan 16, 2015 by matej256
Hi,

I'm using the Planned Cost Finish attribute in custom built report. The option "Set Planned Cost Dates" is not checked, so I can set the date manually.
After setting the value in Project -> Budget -> Planned cost finish, when I check the database - table FIN_FINANCIALS.planned_cst_finish, I can see that the value stored in database is different from the one displayed in Clarity.
For example Planned Cost Finish date displayed in Clarity is 9/27/2012, but the query from database returns 9/28/2012...

SQL used:

SELECT fin.planned_cst_finish
FROM prproject proj
JOIN inv_investments inv
ON inv.ID = proj.prid
JOIN ODF_OBJECT_INSTANCE_MAPPING MAP
ON INV .ID = MAP . PRIMARY_OBJECT_INSTANCE_ID
AND MAP.primary_object_instance_code = 'project'
AND MAP.secondary_object_instance_code = 'financials'
JOIN FIN_FINANCIALS FIN
ON MAP . SECONDARY_OBJECT_INSTANCE_ID = FIN .ID
where proj.prid = <project id>;


Is there any setting/job which does cause the difference - or how can I get the value as seen in the application into the custom report (read it from the db) ?

Thanks in advance for your thoughts !

Outcomes