1 Reply Latest reply on Sep 19, 2013 7:27 PM by Ven

    Problem with extending W_DAY_D table



      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?