FIN_FINANCIALS has fields for planned, budgeted and forecasted values, but I do not see a field for actual CAP or OP cost.
In the reference is says
PFM_INVESTMENTS
This table contains copy of investment attributes in the context of a portfolio.
ACTUAL_CAP_COST BLOB : NULL This column contains a time varying curve representing actual capital cost.
ACTUAL_OP_COST BLOB : NULL This column contains a time varying curve representing actual operating cost.
If they are copies I cannot find the source.
They are blobs and you cannot see the summary value nor the timescaled values.
I tried to locate the summary values, but could not find them either. They might be a virtual fields.
If you are looking for the timescaled values see
ODF_SL_ACTUAL_CAP_COST_TSV
ODF_SL_ACTUAL_OP_COST_TSV
With those your are limited to the system defined time slices.
Original Message:
Sent: 09-02-2020 10:43 PM
From: Uruj Pruthi
Subject: Captial and Operating Actual Cost
Thanks, but this did not help. I found Actual Cost- Capital and Operating in PFM_investments but it is like below
------------------------------
Regards
Uruj
Original Message:
Sent: 09-02-2020 01:35 PM
From: Martti Kinnunen
Subject: Captial and Operating Actual Cost
Have look at the db Entity Relationship Diagrams and FIN_FINANCIALS.
Looking at the object attributes might help if you do not have a db Reference.
Original Message:
Sent: 09-02-2020 01:02 AM
From: Uruj Pruthi
Subject: Captial and Operating Actual Cost
Hi All,
Can someone help me with database table names from where I can get Capital Actual cost and Operating cost of a project. I found pfm_investments but the cost is coded.
------------------------------
Regards
Uruj
------------------------------