Enquiry on usage of FA extract tables for developing BIP reports
- We have a requirement to develop BIP reports.
- We already have the FA extract process run post every period close.
- Wanted to check the feasibility of using FA extract tables for developing the BI reports, as the tables FA_BALANCES_EXTRACT and FA_DEPRN_EXTRACT have all the required information.
- There are 7 books, and the extract tables have approximately 30 million rows of data for each book every year.
- We wanted to understand the limitation of the FA extract tables and more information on the maximum data load, if we wanted to use these tables in the future.
Tagged:
0