Need info on Oracle Fixed Asset tables needed for creating Property/Asset Dimension
I need to create a table from existing tables of Oracle EBS Fixed assets which should have all the information related to creating an Property/Asset, which is used as Dimension in a Datawarehouse. Can you please give some thoughts on this.
Or
Please provide set of tables related to creating an Asset.
Currently, I have gathered below tables:
FA_BOOK_CONTROLS
FA_BOOK_CONTROLS_HISTORY
FA_FISCAL_YEAR
FA_CATEGORY_BOOK_DEFAULTS
FA_CATEGORY_BOOK
Thanks in advance
Gary