Asset Key Flexfield
|
| Owner
| Oracle Assets
|
| Flexfield Code
| KEY#
|
| Table Name
| FA_ASSET_KEYWORDS
|
| Number of Columns
| 10
|
| Width of Columns
| 30
|
| Dynamic Inserts Possible
| Yes
|
| Unique ID Column
| CODE_COMBINATION_ID
|
| Structure Column
| None
|
Oracle Assets uses the asset key flexfield to group your assets by non-financial information. You design your asset key flexfield to record the information you want. Then you group your assets by asset key so you can find them without an asset number.
Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.
Group Assets According To Your Needs
Use the asset key flexfield to group your assets. Group your assets according to non-financial information. You can assign the same asset key to many assets to easily find similar assets. All Oracle Assets transaction forms allow you to query using the asset key, and help you find your assets without an asset number.
Asset Key Flexfield Structure
You define your asset key 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 asset key flexfield. You can define up to ten asset key segments. This key flexfield supports only one structure.
If you choose not to track assets using the asset key, you must define at least one segment asset key flexfield without validation.
Determine Your Needs
Asset Key Structure
Consider the way you group and query your assets. You need to decide how many levels (segments) your asset key structure needs.
Value Sets
Each segment of your asset key structure needs a value set. The terms you used to group your assets are the values you enter for these value sets.
Suggestion: The asset key name (all segments concatenated) appears on forms and reports which display only a limited number of characters. You may want to abbreviate some asset key segment values.
Define Your Asset Key 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 Asset Asset Key Flexfield
Define new asset key segments using the Define Key Segments form. Remember, you must log into Oracle Assets again before you add assets after you recompile your key flexfield.
If you want to define all valid combinations and prevent users from creating additional combinations while entering assets, uncheck Allow Dynamic Inserts. If you do not need to limit valid combinations, check Allow Dynamic Inserts. You can define valid combinations in the Define Asset Key Flexfield Combinations form. See: Key Flexfield Segments.
Define Values For Each Segment
Create a list of valid values for each segment using the Segment Values Window. Since Oracle Assets only displays a limited number of characters of the asset key flexfield on forms and reports, you may want to keep the values short. See: Segment Values Window.
Create Asset Key Flexfield Combinations
Use the Define Asset Key Flexfield Combinations form to enter the combination using the segments you defined. You do not need to use this form to define combinations if you checked Allow Dynamic Inserts.
Example
You decide to use a two segment asset key flexfield. A typical asset key combination might be JET 10.ENGINE. To set up your asset key flexfield you must set up value sets, enable your segments, and enter valid segment values.
First, use the Value Set windows to set up a value set for each segment. For example, you create the value sets Project and Component.
Then use the Key Flexfield Segments window to enable your segments. Enter each segment and the value set for validation in the Segments window.
Now use the Segment Values windows to enter the valid values for each asset key segment. For example, you enter JET 10 as a valid value for the Project segment.
Now, when you enter an asset, you can specify JET 10.ENGINE as the asset key. Since you checked Allow Dynamic Inserts, Oracle Assets creates the combination for you if it doesn't already exist. Or you can create the combination explicitly in the Define Asset Key Flexfield Combinations form.
See Also
Key Flexfields by Flexfield Name
Key Flexfields by Owning Application
