Clarity

Expand all | Collapse all

No Records found in Slice table ODF_SSL_CST_DTL_ACOST

Jump to Best Answer
  • 1.  No Records found in Slice table ODF_SSL_CST_DTL_ACOST

    Posted 07-06-2017 03:58 PM

    Hi,

     

    I am trying to develop a query to fetch Actual Cost from the Cost Plan of Record, for a particular month. But there is no records I found in the table ODF_SSL_CST_DTL_ACOST, in which I believe the slice values for Cost Plan Actual cost should be there. And this slice is active in back-end too. I cannot use PPA_WIP tables since it will not be equal with Actual Cost showing in the cost plan always. Can anyone help me?

     

    Thanks,

    Justine



  • 2.  Re: No Records found in Slice table ODF_SSL_CST_DTL_ACOST
    Best Answer

    Posted 07-06-2017 08:15 PM

    Hi Justinee,

    Not all internal slice tables are meant to have the slice data populated from the UI. 

    As far as I understand, its only the planned cost which gets stored in the slice tables. The actuals and variances are calculated on the fly and not stored in the slice tables. 

    As recommended in the other thread, customers usually use WIP tables to pull out the cost and I have also explained in what circumstances, the cost will not match the cost plan and wip tables. 

     

    Thanks,

    Jerin



  • 3.  Re: No Records found in Slice table ODF_SSL_CST_DTL_ACOST

    Posted 07-19-2017 06:46 AM

    Hello Justine,

     

    Atlernatively, you can refer the following DB Tables:

     

    1. fin_plans

    2. odf_ca_costplan

    3. fin_cost_plan_details

    4. odf_ca_costplandetail

     

    Hope this helps!

     

    Suhail.

     



  • 4.  Re: No Records found in Slice table ODF_SSL_CST_DTL_ACOST

    Posted 07-20-2017 06:00 AM

    Hi Suhail,

     

    I couldn't find the Actual Cost slice data in those tables.

     

    Thanks,

    Justine



  • 5.  Re: No Records found in Slice table ODF_SSL_CST_DTL_ACOST

    Posted 07-22-2017 12:09 AM

    Use ODF_SSL_CST_DTL_COST table to get actual cost information.

     

    Thanks

    Senthil