Location Flexfield
|
| Owner
| Oracle Assets
|
| Flexfield Code
| LOC#
|
| Table Name
| FA_LOCATIONS
|
| Number of Columns
| 7
|
| Width of Columns
| 30
|
| Dynamic Inserts Possible
| Yes
|
| Unique ID Column
| LOCATION_ID
|
| Structure Column
| None
|
Oracle Assets uses the location flexfield to group your assets by physical location. You design your location flexfield to record the information you want. Then you can report on your assets by location. You can also transfer assets that share location information as a group, such as when you move an office to a new location.
Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.
Track Asset Location According To Your Needs
Define the location flexfield to fit the way you track your asset locations. Use the location flexfield to track the physical location of your assets. For example, if you do business internationally (or plan to do so in the future), you may want to track the country an asset is in. Other segments you may want include are state, city, and site. If you track asset location to more detail, such as for barcoding, you can also add segments for building and room number.
Location Flexfield Structure
You define your location flexfield structure to fit the specific needs of your organization. You choose the number of segments, the length of each segment, and the name and order of each segment in your location flexfield. You must define a state segment and you can also define up to six other location segments.
Property Tax Reporting
You can run the Property Tax Report for your states. The Property Tax Report sorts your assets by the location segment with the state qualifier set to Yes.
Mass Transfer By Location
You can transfer assets that share location information as a group. Or you can use the location as a criterion to select assets to transfer between employees or general ledger expense accounts.
Determine Your Needs
Location Structure
Consider the way you track asset location. You need to decide how many levels (segments) your location structure needs. Also decide which is the state segment.
Value Sets
Each segment of your location structure needs a value set. The terms you used to describe your asset locations are the values you enter for these value sets.
Suggestion: The location name (all segments concatenated) appears on forms and reports which only display a limited number of characters. You may want to abbreviate some location segment values.
You must define exactly one State segment when setting up your location flexfield. Specify which segment is your state segment by checking Enabled for the State qualifier in the Segments window. You can run the Property Tax Report for your states.
Define Your Location Flexfield
Create A Value Set For Each Segment
Create a value set for each segment using the Value Set windows. If you want to set up a segment which is dependent on another segment, create an independent value set for the segment which the user enters first, and a dependent value set for the segment which depends on the value entered. See: Value Set Windows.
Alternatively you can set up cascading dependencies for your category flexfield value sets. See: Example of $FLEX$ Syntax.
Enable Each Segment For Your Location Flexfield
Define new location segments using the Define Key Segments form. For your state segment, check Enabled for the State qualifier. Remember, you must log into Oracle Assets again to add assets after you recompile your key flexfield.
If you want to define all valid locations and prevent users from creating additional location flexfield combinations while entering assets, uncheck Allow Dynamic Inserts. If you do not need to limit valid locations, check Allow Dynamic Inserts. You can define valid location flexfield combinations in the Locations form.
If you want to define shorthand aliases for your location flexfield, check Enable Shorthand Flexfield Entry. You can then set up aliases to represent your locations in the Shorthand Aliases window. See: Key Flexfield Segments. See: Shorthand Aliases.
Define Values For Each Segment
Create a list of valid values for each segment using the Segment Values form. Since Oracle Assets only displays a limited number of characters of the location flexfield on forms and reports, you may want to keep the values short. See: Segment Values Window.
Create Locations
Use the Locations form to enter the location name using the segments you defined. You do not need to use this form to define locations if you checked Allow Dynamic Inserts.
You decide to use a three segment location flexfield. A typical location combination might be UK.OXFORDSHIRE.BDG3. To set up your location flexfield you must set up value sets, enable your segments, enter valid segment values, and set up the location.
First, use the Value Set windows to set up a value set for each segment. For example, you create the value sets Country, District Council, and Site.
Then use the Key Flexfield Segments windows to enable your segments. Enter each segment and the value set for validation in the Segments window. For the District Council segment, enable the State qualifier.
Now use the Segment Values windows to enter the valid values for each segment. For example, you enter UK as a valid value for the Country segment.
Finally, use the Locations window to enter the location flexfield combination UK.OXFORDSHIRE.BDG3.
Flexfield Qualifiers
State
You must have exactly one State segment in your Location Flexfield. Oracle Assets uses the State segment for property tax reporting.
See Also
Key Flexfields by Flexfield Name
Key Flexfields by Owning Application
