Oracle E-Business Suite (EBS) List of Flexfields

This post is simply a table listing of the Key Flexfields (KFFs) in Oracle E-Business Suite (EBS) (aka Oracle Applications). 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.

NameCodeOwning ApplicationTable Name
1Account AliasesMDSPOracle InventoryMTL_GENERIC_DISPOSITIONS
2Accounting FlexfieldGL#Oracle General LedgerGL_CODE_COMBINATIONS
3Activity FlexfieldFEACEnterprise Performance Foundation 
4AHL RouteAHLRComplex Maintenance, Repair, and Overhaul 
5Asset Key FlexfieldKEY#Oracle AssetsFA_ASSET_KEYWORDS
6Bank Details KeyFlexFieldBANKOracle PayrollPAY_EXTERNAL_ACCOUNTS
7CAGR FlexfieldCAGROracle Human Resources 
8Category FlexfieldCAT#Oracle AssetsFA_CATEGORIES
9Competence FlexfieldCMPOracle Human Resources 
10Cost Allocation FlexfieldCOSTOracle PayrollPAY_COST_ALLOCATION_KEYFLEX
11Grade FlexfieldGRDOracle Human ResourcesPER_GRADE_DEFINITIONS
12Item CatalogsMICGOracle InventoryMTL_ITEM_CATALOG_GROUPS
13Item CategoriesMCATOracle InventoryMTL_CATEGORIES
14Job FlexfieldJOBOracle Human ResourcesPER_JOB_DEFINITIONS
15Location FlexfieldLOC#Oracle AssetsFA_LOCATIONS
16Oracle Service Item FlexfieldSERVOracle InventoryMTL_SYSTEM_ITEMS
17People Group FlexfieldGRPOracle PayrollPAY_PEOPLE_GROUPS
18Personal Analysis FlexfieldPEAOracle Human ResourcesPER_ANALYSIS_CRITERIA
19Position FlexfieldPOSOracle Human ResourcesPER_POSITION_DEFINITIONS
20Public Sector BudgetingBPSOracle Public Sector Budgeting 
21Sales OrdersMKTSOracle InventorySALES_ORDER_ID
22Sales Tax Location FlexfieldRLOCOracle ReceivablesAR_LOCATION_COMBINATIONS
23Soft Coded KeyFlexfieldSCLOracle Human ResourcesHR_SOFT_CODING_KEYFLEX
24Stock LocatorsMTLLOracle InventoryMTL_ITEM_LOCATIONS
25System ItemsMSTKOracle InventoryMTL_SYSTEM_ITEMS
26Territory FlexfieldCT#Oracle ReceivablesRA_TERRITORIES
27Training ResourcesRESOracle Learning Management
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Topics Covered

Purchasing Concurrent program INVENTORY MODULE Inventory Concepts Min-Max Puchasing Sales Order Supply Chain Management Xml Publisher dff Alert Creation Assembly Pull Assigning Approval Groups Assigning Item BOM Tables Backend Tables Base Tables Bills of Material Tables CATALOG TABLES CATEGORY TABLES Closed not Summarized Concurrent Programs Concurrent Request Consigned and VM Inventory Count (*) Customer Items Customer Items Architecture DDL DML Defining Line Type Defining Subinventories Drop Ship EBS EVEN NUMBERED Error: - APP-PER-50022 FND Tables FRM-40735 Fetch Item Information Flexfields Functional GENERIC DISPOSITIONS Hosting ITEM LOCATIONS TABLE Idle Session Timeout Important questions Introduction to Database Invalid Identifier Error Inventory Inventory Implementation Inventory Item master Inventory Transaction Item Attributes Item Cross Reference Item Defining Attributes Item Deletion Item Master Item Relationships Item Status Attributes Item Tables Java Setup for R12 Key Tables Location Creation Lot and Serial Manufacturer Items Move order Normalization ODD NUMBERED ORA-29273 ORDER MANAGEMENT Oracle Apps Oracle Instance Oracle Order Management PURCHASING MODULE Payable Table Payment Terms Procure to Pay Cycle Profile Categories Purchase - PO Revisions Purchase - Purchase Document Types Purchase Order Purchasing - Define Buyers Purchasing - Defining Approval Groups Purchasing - Invoice matching Purchasing Options Quotations Quote Analysis RFQ RICE Components Receipt Routings Receivables (AR) Tables Receiving Options Registration of a Report Requisition Templates Responsibility Query SALES ORDER TABLE SALES PERSON CREATION SCM Service Contract Sql Self Joins Subinventory Subinventory Transfer Supplier Lists Suppliers TEMP Tablespace Toad Value Sets Wildcard Workflow copy column find an PO details implementation inbound order to cash org_id out bound out of the box implementation vanilla implementation