10/13
eAM Descriptive Flexfields
This chapter covers the following topics:
eAM Descriptive Flexfields
A flexfield is a field comprised of sub-fields, or segments. There are two types of flexfields: key flexfields and descriptive flexfields. A key flexfield appears on your form as a normal text field with an appropriate prompt. A descriptive flexfield appears on your form as a two-character-wide text field with square brackets [ ] as its prompt. When opened, both types of flexfields appear as a pop-up window that contains a separate field and prompt for each segment. Each segment has a name and a set of valid values. The values might also have value descriptions.
Descriptive flexfields provide customizable "expansion space" on your windows and pages. You can use descriptive flexfields to track additional information, important and unique to your business, that would not otherwise be captured by the window. Descriptive flexfields can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the window.
A descriptive flexfield appears on a form as a single-character, unnamed field enclosed in brackets. Just like with a key flexfield, a pop-up window appears when you move your cursor into a customized descriptive flexfield. Like a key flexfield, the pop-up window has as many fields as your organization needs.
Each field or segment in a descriptive flexfield has a prompt, just like ordinary fields, and can have a set of valid values. Your organization can define dependencies among the segments or customize a descriptive flexfield to display context-sensitive segments, so that different segments or additional pop-up windows appear depending on the values you enter in other fields or segments.
The following is a list of eAM's Descriptive Flexfields:
Form: Define Asset Number
ASSET_NUMBERS.DESC_FLEX |
Serial Numbers |
Oracle Inventory |
ASSET_NUMBERS.DESC_FLEX_MIR |
Serial Numbers |
Oracle Inventory |
ATTRIBUTE_VALUES.DESC_FLEX |
Asset Attributes |
Oracle Inventory |
EAM_ASSET_ACTIVITIES.DESC_FLEX |
Asset Activity Association |
Oracle Inventory |
NETWORK_ASSET_ASSOC.DESC_FLEX |
Asset Routes Association |
Oracle Inventory |
Form: Asset Route
ASSET_NUMBERS.DESC_FLEX |
Serial Numbers |
Oracle Inventory |
ASSET_NUMBERS.DESC_FLEX_MIR |
Serial Numbers |
Oracle Inventory |
ATTRIBUTE_VALUES.DESC_FLEX |
Asset Attributes |
Oracle Inventory |
EAM_ASSET_ACTIVITIES.DESC_FLEX |
Asset Activity Association |
Oracle Inventory |
NETWORK_ASSET_ASSOC.DESC_FLEX |
Asset Routes Association |
Oracle Inventory |
Form: Define Rebuildable Serial Number
ASSET_NUMBERS.DESC_FLEX |
Serial Numbers |
Oracle Inventory |
ASSET_NUMBERS.DESC_FLEX_MIR |
Serial Numbers |
Oracle Inventory |
ATTRIBUTE_VALUES.DESC_FLEX |
Asset Attributes |
Oracle Inventory |
EAM_ASSET_ACTIVITIES.DESC_FLEX |
Asset Activity Association |
Oracle Inventory |
NETWORK_ASSET_ASSOC.DESC_FLEX |
Asset Routes Association |
Oracle Inventory |
Form: Rebuildable Routings
B_OP_RES.DF |
Operation Resources |
Oracle Bills of Material |
B_OP_RTGS.DF |
Routing flex |
Oracle Bills of Material |
B_OP_RTGS.DF_MIRROR |
Routing flex |
Oracle Bills of Material |
B_OP_SEQS.DF |
Operation Information |
Oracle Bills of Material |
B_RTG_REVS.DF |
Routing revisions |
Oracle Inventory |
B_SUB_OP_RES.DF |
Sub Operation Resources |
Oracle Bills of Material |
Form: Work Order
EAM_WORKORDERS.DESC_FLEX_MIR |
Discrete Job |
Oracle Work in Process |
OPERATIONS.DESC_FLEX |
Operation Information |
Oracle Bills of Material |
REQUIREMENTS.DESC_FLEX |
Component Information |
Oracle Bills of Material |
RESOURCES.DESC_FLEX |
Operation Resources |
Oracle Bills of Material |
Form: Rebuild Work Order
EAM_WORKORDERS.DESC_FLEX_MIR |
Discrete Job |
Oracle Work in Process |
OPERATIONS.DESC_FLEX |
Operation Information |
Oracle Bills of Material |
REQUIREMENTS.DESC_FLEX |
Component Information |
Oracle Bills of Material |
RESOURCES.DESC_FLEX |
Operation Resources |
Oracle Bills of Material |
Form: Close Work Order
EAM_WORKORDERS.DESC_FLEX_MIR |
Discrete Job |
Oracle Work in Process |
OPERATIONS.DESC_FLEX |
Operation Information |
Oracle Bills of Material |
REQUIREMENTS.DESC_FLEX |
Component Information |
Oracle Bills of Material |
RESOURCES.DESC_FLEX |
Operation Resources |
Oracle Bills of Material |
Form: Operations
OPERATIONS.DESC_FLEX |
Operation Information |
Oracle Bills of Material |
REQUIREMENTS.DESC_FLEX |
Component Information |
Oracle Bills of Material |
RESOURCES.DESC_FLEX |
Operation Resources |
Oracle Bills of Material |
Form: Material Requirement
REQUIREMENTS.DESC_FLEX |
Component Information |
Oracle Bills of Material |
Form: Pending Resource Transactions
RESOURCE_TRANSACTIONS.DESC_FLEX WIP |
Resource Transaction |
Oracle Work in Process |
Form: View Resource Transactions
W_TXNS_V.DESC_FLEX WIP |
Resource Transaction |
Oracle Work in Process |
Form: Work Order Completion
WO_COMPLETION.DF |
Work Order Completion Information |
Oracle Enterprise Asset Management |
Form: Rebuild Work Order Completion
REBUILD_COMPLETION.DESC_FLEX |
Work Order Completion Information |
Oracle Enterprise Asset Management |
Form: Set Name Definition
SET_NAMES.DF |
Preventive Maintenance Set Name |
Oracle Enterprise Asset Management |
Form: Suppression
SUPPRESSIONS.DF |
Suppression Information |
Oracle Enterprise Asset Management |
Form: Meter Readings
METER_READING.DESCRIPTIVE_FLEX |
Meter Reading Information |
Oracle Enterprise Asset Management |
Related Topics
Descriptive Flexfields, Oracle Applications Flexfield Guide
Benefits of Flexfields, Oracle Applications Flexfield Guide
Basic Flexfield Concepts, Oracle Applications Flexfield Guide