In Oracle E-Business Suite Release 12 (R12), the Enterprise Asset Management (EAM) module uses several base tables
to store asset-related information. These tables are linked together through common keys to provide a comprehensive view of asset data.
Here's an overview of the key base tables and their links:
1. FA_ASSET_HISTORY:
- Links to: FA_ASSET_ID
2. FA_ASSET_RETIREMENTS:
- Links to: FA_ASSET_ID
3. FA_ADDITIONS_B:
- Links to: FA_ASSET_ID
4. FA_BOOKS:
- Links to: FA_BOOK_TYPE_CODE
5. FA_CATEGORIES_B:
- Links to: FA_CATEGORY_ID
6. FA_DEPRN_DETAIL:
- Links to: FA_TRANSACTION_HEADER_ID
7. FA_LOCATIONS:
- Links to: LOCATION_ID
8. FA_PERIODS:
- Links to: FA_CALENDAR_NAME
9. FA_TRANSACTIONS:
- Links to: FA_TRANSACTION_HEADER_ID
10. FA_TRANSACTION_HEADERS:
- Links to: FA_TRANSACTION_HEADER_ID
11. FA_TRANSACTION_LINES:
- Links to: FA_TRANSACTION_HEADER_ID
12. FA_MASS_ADDITIONS:
- Links to: FA_MASS_ADDITION_ID
13. EAM_WORK_ORDERS:
- Links to: WORK_ORDER_ID
14. EAM_TASKS:
- Links to: TASK_ID, WORK_ORDER_ID
15. EAM_RESOURCES:
- Links to: RESOURCE_ID, TASK_ID
These links represent the primary relationships between the key base tables in the Enterprise Asset Management module of Oracle Apps R12.
By joining these tables using the appropriate keys, you can construct queries to extract comprehensive asset-related information,
including asset history, additions, retirements, depreciation details, locations, transactions, work orders, tasks, and assigned resources.
No comments:
Post a Comment