Asset Category is defined in E-Business Suite Fixed Asset Application using the Key Flex Field (KFF) feature. You can setup KFF using different segments based on your business needs.
The configuration file file_fa_category_segment_config_ora.csv
is used to configure the segment mapping between the Category KFF in your E-Business Suite Fixed Asset application and the Asset Category dimension in Oracle Business Analytics Warehouse. This configuration needs to be done before the ETL load. During ETL, the configuration csv file determines which KFF segment should be loaded into which segment column in the Asset Category dimension table in Oracle Business Analytics Warehouse.
For example, assuming in Oracle Business Analytics Warehouse, the segment columns store the following conformed values:
W_ASSET_CATEGORY_D.major_category stores Major category (such as COMPUTER)
W_ASSET_CATEGORY_D.minor_category stores Minor category (such as LAPTOP, or DESKTOP)
W_ASSET_CATEGORY_D.segment1 stores Major category
W_ASSET_CATEGORY_D.segment2 stores Minor category
Assuming in your E-Business Suite instance, you use segment 2 and segment 3 to store the major and minor category:
FA_CATEGORIES_B.segment1 not used
FA_CATEGORIES_B.segment2 stores Major category
FA_CATEGORIES_B.segment3 stores Minor category
With this example, the configure csv file should be configured as the follows:
MAJOR_CATEGORY | MINOR_CATEGORY | SEG1 | SEG2 | SEG3 | SEG4 | SEG5 | Etc |
---|---|---|---|---|---|---|---|
SEGMENT2 |
SEGMENT3 |
SEGMENT2 |
SEGMENT3 |
Note:
The major_category and minor_category columns contain the segment numbers that represents the major and minor category respectively.How to configure the Asset Category Dimension using file_fa_category_segment_config_ora.csv
: