Configure the Inline Dataset for the Asset Location Dimension
Use these steps to configure the inline dataset for the location dimension.
-
Edit the EBS_CONFIG DA Script application
-
Navigate to the Functional_configurations.hrf → FILE_FA_LOCATION_SEGMENT_CONFIG_ORA inline dataset
-
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.