Configuring the Asset Category Dimension for E-Business Suite
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
: