fa periods tables

fa periods tables

In this post , We will be discuss about fa periods tables. fa period tables stores informations about FA periods in oracle application. There are different types of period tables in fa and each fa periods stores different fa period informations. Here below is the detail about fa periods tables.

fa periods tables

2 Type of fa periods tables

1.FA_DEPRN_PERIODS

2.FA_CALENDAR_PERIODS

FA_DEPRN_PERIODS:-

This tables contains information about your depreciation periods. Oracle Assets uses this table to determine when each period in FA_CALENDARS was open for a depreciation book. PERIOD_OPEN_DATE and PERIOD_CLOSE_DATE are the dates when you opened and closed each book’s depreciation period. Each time you run the depreciation program, it closes the current period by setting PERIOD_CLOSE_DATE to the system date. It also opens the next period by inserting a new row into this table in which PERIOD_CLOSE_DATE is NULL and PERIOD_OPEN_DATE equals the PERIOD_CLOSE_DATE of the old row.

FA_CALENDAR_PERIODS:-

This Table contains CALENDAR_PERIOD_OPEN_DATE and CALENDAR_PERIOD_CLOSE_DATE correspond to your calendar as defined by the START_DATE and END_DATE columns in FA_CALENDAR_PERIODS.