Clarity

 View Only
  • 1.  Captial and Operating Actual Cost

    Posted Sep 02, 2020 01:02 AM
    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
    ------------------------------


  • 2.  RE: Captial and Operating Actual Cost

    Posted Sep 02, 2020 01:35 PM

    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.




  • 3.  RE: Captial and Operating Actual Cost

    Posted Sep 02, 2020 10:44 PM
    Thanks, but this did not help. I found Actual Cost- Capital and Operating in PFM_investments but it is like below


    How to convert this to numbers?


    ------------------------------
    Regards
    Uruj
    ------------------------------



  • 4.  RE: Captial and Operating Actual Cost
    Best Answer

    Posted Sep 03, 2020 04:16 AM
    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.


  • 5.  RE: Captial and Operating Actual Cost

    Broadcom Employee
    Posted Sep 03, 2020 09:01 AM
    You can also get the actual costs based on financial transactions from PPA_WIP_VALUES
    You will have to join that to PPA_WIP as that is where cost type is as well as transdate and other information.

    I normally do something like this

    SELECT w.cost_type,
    wv.totalcost,
    w.project_code,
    w.quantity
    FROM PPA_WIP w
    INNER JOIN PPA_WIP_VALUES wv
    ON w.TRANSNO = wv.TRANSNO
    WHERE wv.CURRENCY_TYPE = 'HOME'

    Liz Williamson