We have added 4 joins and the 4th join below is causing a time out issue and can't figure out a way around it. We are using parameters and a date range of only a month via scheduled process. We will be adding the Period as a parameter as well, but at this time we have not done so, due to this other issue.
LEFT OUTER JOIN FA_BOOK_CONTROLS fbc on FA_BOOKS.BOOK_TYPE_CODE = fbc.BOOK_TYPE_CODE
LEFT OUTER JOIN FA_FISCAL_YEAR_TYPES_B fft ON fbc.FISCAL_YEAR_NAME = fft.FISCAL_YEAR_NAME
LEFT OUTER JOIN fa_calendar_types fcalt on fft.FISCAL_YEAR_NAME = fcalt.FISCAL_YEAR_NAME
LEFT OUTER JOIN FA_CALENDAR_PERIODS fcp on fcalt.CALENDAR_TYPE = fcp.CALENDAR_TYPE
