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:

  1. Edit the file file_fa_category_segment_config_ora.csv.

    The file_fa_category_segment_config_ora.csv is used to match the segment fields in E-Business Suite to the segment fields the Oracle Business Analytics Warehouse table W_ASSET_CATEGORY_D.

    The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:

    • Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.

    • Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.

    Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.

  2. Enter the segment mapping information into the fields.

    The column SEG1 to SEG7 represent Oracle Business Analytics Warehouse segment columns in the asset category dimension table. For each of these segments, you fill in the corresponding mapped KFF segment. Fill the MAJOR_CATEGORY and MINOR_CATEGORY column with the segment number that represents the major and minor category respectively.

    Leave the field empty if there is no mapping.

  3. Save the file.