1 Reply Latest reply: Sep 19, 2013 2:27 PM by Ven RSS

    Problem with extending W_DAY_D table

    Ven

      Hi,


      We are implementing BI Apps 7.9.6 for Oracle EBS - Fins. Configured time dimension's $$END_DATE to 12/31/2015. After a full load, all tasks are completed successfully but time dimension tables are populated up-to 12/31/2010 only.

       

      Exactly followed how Oracle suggested on extending W_DAY_D.  Went thru other previous forum discussions on this topic but none worked for me.


      I changed the ownership of SIL_DayDimension, SIL_TimeDimension_MCALPeriod tasks and $$START_DATE, $$END_DATE parameters to custom container where my subject area lives but no change.  The parameter file generated by DAC is always $$END_DATE=12/31/2010 for these two tasks.

       

      Not sure where and why it is picking a wrong END_DATE value.

       

      Is any of you faced this issue before?

       


      Thanks.

      Ven