Asset Location is defined in the Fixed Asset Application in E-Business Suite using the Key Flex Field (KFF) feature. You set up KFF using different segments based on your business needs. For example, one source system might have KFF set up using segment 1, 2, 3, 4 for country, state, city and address, while another source system might have segment 1, 2, 3, 4 for address, city, state, and country, or other additional information.
The configuration file file_fa_location_segment_config_ora.csv is used to configure the segment mapping between the Location KFF in your Fixed Asset application and the Asset Location dimension in Oracle Business Analytics Warehouse. You must configure this file before you start ETL.
Setting up the config file: file_fa_location_segment_config_ora.csv
The file_fa_location_segment_config_ora.csv is to be used to match the segment fields in E-Business Suite to the segment fields in the asset location table W_ASSET_LOCATION_D in Oracle Business Analytics Warehouse.
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.
Note:
If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows: 1. From the Tasks bar, click Define Business Intelligence Applications. 2. Click Actions, then Manage Source Configuration Data Files. 3. Click the Export Source Configuration Data Files option on the tool bar. 4. Move the required files to the right hand list, then click Export.Edit this file and fill in the segment mapping info. The column SEG1 to SEG7 represent Oracle Business Analytics Warehouse segment columns in the asset location dimension table. For each of the segments, you fill in the corresponding mapped KFF segment. If there is no mapping, then leave the field empty.
Example
In Oracle Business Analytics Warehouse, the segment columns store the following conformed values:
W_ASSET_LOCATION_D.segment1 stores the value of Country
W_ASSET_LOCATION_D.segment2 stores the value of State
W_ASSET_LOCATION_D.segment3 stores the value of County
W_ASSET_LOCATION_D.segment4 stores the value of City
W_ASSET_LOCATION_D.segment5 stores Address
In the E-Business Suite, County is not used. In KFF you have Country, State, City, and Address, as follows:
FA_LOCATIONS.segment1 stores the value of Country
FA_LOCATIONS.segment2 stores the value of State
FA_LOCATIONS.segment3 stores the value of City
FA_LOCATIONS.segment4 stores the value of Address
To deploy this scenario, configure the file_fa_location_segment_config_ora.csv file:
| SEG1 | SEG2 | SEG3 | SEG4 | SEG5 | SEG6 | SEG7 |
|---|---|---|---|---|---|---|
|
SEGMENT1 |
SEGMENT2 |
<Empty> |
SEGMENT3 |
SEGMENT4 |
<Empty> |
<Empty> |