Configure the Inline Dataset for the Asset Location Dimension

Use these steps to configure the inline dataset for the location dimension.

  1. Edit the EBS_CONFIG DA Script application

  2. Navigate to the Functional_configurations.hrf  →  FILE_FA_LOCATION_SEGMENT_CONFIG_ORA inline dataset

  3. Configure the mapping between the Oracle E-Business Suite Location Key Flexfield (KFF) segments and the corresponding Asset Location dimension (DW_EB_X_EBS_FA_W_ASSET_LOCATION_D) segment columns in Oracle E-Business Suite Data Intelligence.

The columns SEG1 through SEG7 represent the segment columns in the DW_EB_X_EBS_W_ASSET_LOCATION_D dimension table.

For each warehouse segment:

  • Enter the corresponding EBS Location KFF segment number.

  • Leave the field blank if no corresponding KFF segment exists.