[EBS] Oracle E-Business Suite (EBS) List Of Flexfields

Oracle E-Business Suite (EBS) List of Flexfields

This is simply a table listing of the Key Flexfields (KFFs) in Oracle E-Business Suite (EBS) The table contains the flexfields, along with their Code, Owning Application and base table. 

Flexfields are commonly used in OBIEE reporting for EBS source systems. Flexfields are also an integral part of the Oracle Business Analytics Warehouse (OBAW) data model. It is worthwhile to be familiar with them.

Name	Code	Owning Application	Table Name
Account Aliases	MDSP	Oracle Inventory	MTL_GENERIC_DISPOSITIONS
Accounting Flexfield	GL#	Oracle General Ledger	GL_CODE_COMBINATIONS
Activity Flexfield	FEAC	Enterprise Performance Foundation
AHL Route	AHLR	Complex Maintenance, Repair, and Overhaul
Asset Key Flexfield	KEY#	Oracle Assets	FA_ASSET_KEYWORDS
Bank Details KeyFlexField	BANK	Oracle Payroll	PAY_EXTERNAL_ACCOUNTS
CAGR Flexfield	CAGR	Oracle Human Resources
Category Flexfield	CAT#	Oracle Assets	FA_CATEGORIES
Competence Flexfield	CMP	Oracle Human Resources
Cost Allocation Flexfield	COST	Oracle Payroll	PAY_COST_ALLOCATION_KEYFLEX
Grade Flexfield	GRD	Oracle Human Resources	PER_GRADE_DEFINITIONS
Item Catalogs	MICG	Oracle Inventory	MTL_ITEM_CATALOG_GROUPS
Item Categories	MCAT	Oracle Inventory	MTL_CATEGORIES
Job Flexfield	JOB	Oracle Human Resources	PER_JOB_DEFINITIONS
Location Flexfield	LOC#	Oracle Assets	FA_LOCATIONS
Oracle Service Item Flexfield	SERV	Oracle Inventory	MTL_SYSTEM_ITEMS
People Group Flexfield	GRP	Oracle Payroll	PAY_PEOPLE_GROUPS
Personal Analysis Flexfield	PEA	Oracle Human Resources	PER_ANALYSIS_CRITERIA
Position Flexfield	POS	Oracle Human Resources	PER_POSITION_DEFINITIONS
Public Sector Budgeting	BPS	Oracle Public Sector Budgeting
Sales Orders	MKTS	Oracle Inventory	SALES_ORDER_ID
Sales Tax Location Flexfield	RLOC	Oracle Receivables	AR_LOCATION_COMBINATIONS
Soft Coded KeyFlexfield	SCL	Oracle Human Resources	HR_SOFT_CODING_KEYFLEX
Stock Locators	MTLL	Oracle Inventory	MTL_ITEM_LOCATIONS
System Items	MSTK	Oracle Inventory	MTL_SYSTEM_ITEMS
Territory Flexfield	CT#	Oracle Receivables	RA_TERRITORIES
Training Resources	RES	Oracle Learning Management