Descriptive Flexfield (DFF) Search

This appendix covers the following topics:

Overview

Descriptive Flexfields (DFF) provide customizable expansion space on the EBS Endeca user interfaces and are used to track additional information important and unique to the business that would not otherwise be captured. Oracle E-Business Suite Information Discovery supports Descriptive Flex Field (DFF) information and enables you to search on DFF attributes.

When a new descriptive flexfield definition has been created, the descriptive flexfield details will be available after the ETL processes complete. DFF support is available by default within the guided navigation component, and you can refine each of the attributes with specific search and selection criteria. You can also search on results tables, charts, and other components by customizing and configuring the application.

Note: For additional information on configuring and customizing flexfields, see the Oracle E-Business Suite Flexfields Guide and Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1).

Product Descriptive Flexfields

Descriptive Flexfields that are included with Oracle E-Business Suite Information Discovery and supported by individual product extensions include the following:

Product Name Community Name Sandbox Name DFF Title in EBS DFF Name in FND_EID Table
Field Service Tasks csf-tasks csf-tasks Tasks Additional Information JTF_TASKS_B
Field Service Parts csf-parts csf-parts Tasks Additional Information JTF_TASKS_B
Oracle Enterprise Asset Manager Eam eam Operation Information
Operation Resources
Discrete Job
Work Request Information
OPERATIONS
OPERATION_RESOURCES
WIP_DISCRETE_JOBS
WIP_EAM_WORK_REQUESTS
Installed Base Csi csi Item Instance Flexfield Details Item Instance Flex Field
Warehouse Management System, Inventory inv-pf wms Additional Header Information
Additional Line Attribute Information
Additional Delivery Detail Information
OE_HEADER_ATTRIBUTES
OE_LINE_ATTRIBUTES

WSH_DELIVERY_DETAILS
  inv-tf   Additional Delivery Detail Information
Additional Delivery Information
WSH_DELIVERY_DETAILS
WSH_NEW_DELIVERIES
  inv-su   Stock locators
Subinventories
MTL_ITEM_LOCATIONS
MTL_SECONDARY_INVENTORIES
  inv-lu   Stock locators
Subinventories
MTL_ITEM_LOCATIONS
MTL_SECONDARY_INVENTORIES
Inventory Management Extension inv-item inv-item Items MTL_SYSTEM_ITEMS
Projects prj-pjt prj-pjt Projects
Workplan Descriptive Flex
PA_PROJECTS_DESC_FLEX
PA_PROJ_ELEM_VER_SCH_DESC_FLEX
Manufacturing Execution System for Discrete Manufacturing wip-dwo wip-dwo Serial Numbers
Serial Attributes
Operation Information
Discrete Job
Shop Floor Status
MTL_SERIAL_NUMBERS
Serial Attributes
OPERATIONS
WIP_DISCRETE_JOBS
WIP_SHOP_FLOOR_STATUS_CODES
Channel Revenue Management ozf-claim ozf-claim Claims AMS_CLAIM
Channel Revenue Management ozf-budget ozf-budget Budgets AMS_FUND
Order Management ont ont Additional Line Attribute Information OE_LINE_ATTRIBUTES
Depot Repair - Supplier Warranty csd supwar Additional Information
Repair Orders
CS_INCIDENTS_ALL_B_EXT
CSD_REPAIRS
Process Manufacturing gmo-batch gmo-batch Detail Information
Batch Information
Batch Steps Information
Batch Steps Activity Information
Batch Steps Resource Information
BATCH_DTL_FLEX
Batch Information
BATCH_STEPS_DTL_FLEX
GME_BATCH_STEP_ACTIVITIES_FLEX
GME_BATCH_STEP_RESOURCES_FLEX
Cost Management - Landed Cost Management inl-lc inl-lc Shipment Headers
Shipment Lines
INL_SHIP_HEADERS
INL_SHIP_LINES
Receivables ar ar Receipt Information
Transaction Information
AR_CASH_RECEIPTS
RA_CUSTOMER_TRX
Payables ap ap Invoice AP_INVOICES
Service Contracts oks oks Contract Headers
Contract Lines
OKC_HEADERS_DESC_FLEX
OKC_LINES_DESC_FLEX
TeleService service endeca service endeca Additional Information for Agents
Additional Information
CS_INCIDENTS_ALL_B
CS_INCIDENTS_ALL_B_EXT