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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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
Field Descriptive Flexfield Name Descriptive Flexfield Owner
REQUIREMENTS.DESC_FLEX Component Information Oracle Bills of Material
Form: Pending Resource Transactions
Field Descriptive Flexfield Name Descriptive Flexfield Owner
RESOURCE_TRANSACTIONS.DESC_FLEX WIP Resource Transaction Oracle Work in Process
Form: View Resource Transactions
Field Descriptive Flexfield Name Descriptive Flexfield Owner
W_TXNS_V.DESC_FLEX WIP Resource Transaction Oracle Work in Process
Form: Work Order Completion
Field Descriptive Flexfield Name Descriptive Flexfield Owner
WO_COMPLETION.DF Work Order Completion Information Oracle Enterprise Asset Management
Form: Rebuild Work Order Completion
Field Descriptive Flexfield Name Descriptive Flexfield Owner
REBUILD_COMPLETION.DESC_FLEX Work Order Completion Information Oracle Enterprise Asset Management
Form: Set Name Definition
Field Descriptive Flexfield Name Descriptive Flexfield Owner
SET_NAMES.DF Preventive Maintenance Set Name Oracle Enterprise Asset Management
Form: Suppression
Field Descriptive Flexfield Name Descriptive Flexfield Owner
SUPPRESSIONS.DF Suppression Information Oracle Enterprise Asset Management
Form: Meter Readings
Field Descriptive Flexfield Name Descriptive Flexfield Owner
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