Clarity

  • 1.  Benefit plan monthly slice details

    Posted Feb 15, 2018 06:49 AM

    We have created a benefit plan associated to the cost plan of the record and the period type is created ANNUALLY.

     

    I need monthly period cost database tables as i have changed the time scale value from annually to monthly.

     

    In what database tables the benefit plan monthly cost contains.

     

    Thanks



  • 2.  Re: Benefit plan monthly slice details

    Posted Feb 15, 2018 09:26 AM

    See

    Can you provide more details regarding the Financial Planning Slice Tables?

    Document ID:  TEC440146
    Last Modified Date:  02/24/2015

     

    Getting Cost Plan Unit & Cost data in porlets and reports 

     

    In my benefit plan there is no cost.



  • 3.  Re: Benefit plan monthly slice details

    Posted Feb 16, 2018 07:16 AM

    Hi Urmas have you tried using fin_plans -> FIN_BENEFIT_PLAN_DETAILS -> ODF_SSL_BFT_DTL_BBFT (slice table)?

    earlier today I wanted the annual data for the same and got it from Budget/Forecast COST & UNITS breakup 

    hope this helps

    -Ashmi