Asset Location Dimension Configuration Example

Assume the warehouse stores asset location information as follows:

Warehouse Column	Business Meaning
W_ASSET_LOCATION_D.SEGMENT1	Country
W_ASSET_LOCATION_D.SEGMENT2	State
W_ASSET_LOCATION_D.SEGMENT3	County
W_ASSET_LOCATION_D.SEGMENT4	City
W_ASSET_LOCATION_D.SEGMENT5	Address

The EBS Location KFF is configured as follows:

EBS KFF Segment	Business Meaning
FA_LOCATIONS.SEGMENT1	Country
FA_LOCATIONS.SEGMENT2	State
FA_LOCATIONS.SEGMENT3	City
FA_LOCATIONS.SEGMENT4	Address

In this implementation, County is not defined in the EBS Location KFF.

Configure FILE_FA_LOCATION_SEGMENT_CONFIG_ORA as shown below:

SEG1	SEG2	SEG3	SEG4	SEG5	SEG6	SEG7
SEGMENT1	SEGMENT2	<Empty>	SEGMENT3	SEGMENT4	NA	NA