eAM Descriptive Flexfields

This chapter covers the following topics:

eAM Descriptive Flexfields

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