Clarity

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Where are forecast slice values stored when populating cost plan from investment team?

  • 1.  Where are forecast slice values stored when populating cost plan from investment team?

    Posted Jan 08, 2016 10:40 AM


    We have a cost plan with monthly values.  We updated the cost plan with non labor expenses and then populated the labor transaction classes using "populate from investment team".  Problem is, normally I get the month break down of data from the ODF_SSL_CST_DTL_COST CST table.  However, for the records in the cost plan detail table that have a source of "RESOURCEPLAN", I cannot find those records in the slide table.  I then submitted the plan for budget approval and approved the budget.  The labor records on the budget DO appear in the slice table.



  • 2.  Re: Where are forecast slice values stored when populating cost plan from investment team?

    Posted Jan 24, 2016 02:28 PM

    Hi,

     

    You can use the below query to find the correct table for the cost plane slices. Use the second query to find all the tables that are associated with cost.

     

    Select *

    from PRJ_BLB_SLICEREQUESTS SR

    whew SR.REQUEST_NAME = 'costplandetail::cost::segment'

     

    Select *

    from PRJ_BLB_SLICEREQUESTS SR

    whew SR.REQUEST_NAME like '%cost%'