, , , ,

Key Flexfields in Oracle E-Business Suite

The Oracle E-Business Suite products provide many key flexfields as integral parts of the products.

Note: Do not modify the registration of any key flexfield supplied with Oracle E-Business Suite. Doing so can cause serious application errors.

Key Flexfields by Flexfield Name

Here is a table listing many of the key flexfields in Oracle E-Business Suite, ordered by the name of the key flexfield.

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

You use the flexfield code and the owning application to identify a flexfield when you call it from a custom form.

Note: that the following flexfields are single-structure seeded key flexfields: Account Aliases, Item Catalogs, Oracle Service Item Flexfield, Stock Locators, and System Items.

Key Flexfields by Owning Application

Here is a table listing many of the key flexfields in Oracle E-Business Suite, ordered by the application that “owns” the key flexfield. Note that other applications may also use a particular flexfield.

Owner Name Code
Oracle Assets Asset Key Flexfield KEY#
Oracle Assets Category Flexfield CAT#
Oracle Assets Location Flexfield LOC#
Oracle Complex Maintenance, Repair, and Overhaul AHL Route AHLR
Oracle Enterprise Performance Foundation Activity Flexfield FEAC
Oracle General Ledger Accounting Flexfield GL#
Oracle Human Resources CAGR Flexfield CAGR
Oracle Human Resources Competence Flexfield CMP
Oracle Human Resources Grade Flexfield GRD
Oracle Human Resources Job Flexfield JOB
Oracle Human Resources Personal Analysis Flexfield PEA
Oracle Human Resources Position Flexfield POS
Oracle Human Resources Soft Coded KeyFlexfield SCL
Oracle Inventory Account Aliases MDSP
Oracle Inventory Item Catalogs MICG
Oracle Inventory Item Categories MCAT
Oracle Inventory Sales Orders MKTS
Oracle Inventory Stock Locators MTLL
Oracle Inventory Oracle Service Item Flexfield SERV
Oracle Inventory System Items MSTK
Oracle Learning Management Training Resources RES
Oracle Payroll Bank Details KeyFlexField BANK
Oracle Payroll Cost Allocation Flexfield COST
Oracle Payroll People Group Flexfield GRP
Oracle Public Sectory Budgeting PSB Position Flexfield BPS
Oracle Receivables Sales Tax Location Flexfield RLOC
Oracle Receivables Territory Flexfield CT#

Tables of Individual Key Flexfields in Oracle E-Business Suite

The following sections contain a table for individual key flexfields in the Oracle E-Business Suite. These tables provide you with useful information, including:

  • Which application owns the key flexfield
  • The flexfield code (used by forms and routines that call a flexfield)
  • The name of the code combinations table
  • How many segment columns it has
  • The width of the segment columns
  • The name of the unique ID column (the CCID column)
  • The name of the structure ID column
  • Whether it is possible to use dynamic insertion with this key flexfield

Many of these key flexfield sections also contain information on the uses and purpose of the flexfield, as well as suggestions for how you might want to implement it at your site.

Account Aliases

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MDSP
Table Name MTL_GENERIC_DISPOSITIONS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column DISPOSITION_ID
Structure Column ORGANIZATION_ID

This key flexfield supports only one structure.

Accounting Flexfield

The following table lists details for this key flexfield.

Owner Oracle General Ledger
Flexfield Code GL#
Table Name GL_CODE_COMBINATIONS
Number of Columns 30
Width of Columns 25
Dynamic Inserts Possible Yes
Unique ID Column CODE_COMBINATION_ID
Structure Column CHART_OF_ACCOUNTS_ID

The Accounting Flexfield is fully described in the Oracle General Ledger documentation.

Asset Key Flexfield

The following table lists details for this key flexfield.

Owner Oracle Assets
Flexfield Code KEY#
Table Name FA_ASSET_KEYWORDS
Number of Columns 10
Width of Columns 30
Dynamic Inserts Possible Yes
Unique ID Column CODE_COMBINATION_ID
Structure Column None

Oracle Assets uses the asset key flexfield to group your assets by non-financial information. You design your asset key flexfield to record the information you want. Then you group your assets by asset key so you can find them without an asset number.

Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.

Bank Details KeyFlexField

The following table lists details for this key flexfield.

Owner Oracle Payroll
Flexfield Code BANK
Table Name PAY_EXTERNAL_ACCOUNTS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column EXTERNAL_ACCOUNT_ID
Structure Column ID_FLEX_NUM

The Bank Details KeyFlexfield [sic] holds legislation specific bank account information. The Bank Details structure that you see is determined by the legislation of your Business Group.
Localization teams determine the data that is held in this flexfield. Each localization team defines a flexfield structure that allows you to record the bank account information relevant to each legislation.
If you are using a legislation for which a Bank KeyFlexfield structure has been defined you should not modify the predefined structure.

Warning: You should not attempt to alter the definitions of the Bank Details Flexfield which are supplied. These definitions are a fundamental part of the package. Any change to these definitions may lead to errors in the operating of the system.
It is possible that Oracle Human Resources will use the other segments of this flexfield in the future. Therefore, you should not try to add other segments to this Flexfield. This may affect your ability to upgrade the system in the future.
Consult your Oracle Human Resources National Supplement for the full definition of your Bank Details Flexfield.

Category Flexfield

The following table lists details for this key flexfield.

Owner Oracle Assets
Flexfield Code CAT#
Table Name FA_CATEGORIES
Number of Columns 7
Width of Columns 30
Dynamic Inserts Possible No
Unique ID Column CATEGORY_ID
Structure Column None

Oracle Assets uses the category flexfield to group your assets by financial information. You design your category flexfield to record the information you want. Then you group your assets by category and provide default information that is usually the same for assets in that category.

Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.

Cost Allocation Flexfield

The following table lists details for this key flexfield.

Owner Oracle Payroll
Flexfield Code COST
Table Name PAY_COST_ALLOCATION_KEYFLEX
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column COST_ALLOCATION_KEYFLEX_ID
Structure Column ID_FLEX_NUM

You must be able to get information on labor costs from your payrolls, and send this information to other systems. Payroll costs must of course go to the general ledger. Additionally, you may need to send them to labor distribution or project management systems.
The Cost Allocation Flexfield lets you record, accumulate and report your payroll costs in a way which meets the needs of your enterprise.

Grade Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code GRD
Table Name PER_GRADE_DEFINITIONS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column GRADE_DEFINITION_ID
Structure Column ID_FLEX_NUM

Grades are used to represent relative status of employees within an enterprise, or work group. They are also used as the basis of many Compensation and Benefit policies.

Item Catalogs

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MICG
Table Name MTL_ITEM_CATALOG_GROUPS
Number of Columns 15
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column ITEM_CATALOG_GROUP_ID
Structure Column None

This key flexfield supports only one structure.

Item Categories

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MCAT
Table Name MTL_CATEGORIES
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column CATEGORY_ID
Structure Column STRUCTURE_ID

You must design and configure your Item Categories Flexfield before you can start defining items since all items must be assigned to categories.
You can define multiple structures for your Item Categories Flexfield, each structure corresponding to a different category grouping scheme. You can then associate these structures with the categories and category sets you define.

Job Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code JOB
Table Name PER_JOB_DEFINITIONS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column JOB_DEFINITION_ID
Structure Column ID_FLEX_NUM

The Job is one possible component of the Employee Assignment in Oracle Human Resources. The Job is used to define the working roles which are performed by your employees. Jobs are independent of Organizations. With Organizations and Jobs you can manage employee assignments in which employees commonly move between Organizations but keep the same Job.
You use the Job Flexfield to create Job Names which are a unique combination of segments. You can identify employee groups using the individual segments of the Job whenever you run a report or define a QuickPaint.

Location Flexfield

The following table lists details for this key flexfield.

Owner Oracle Assets
Flexfield Code LOC#
Table Name FA_LOCATIONS
Number of Columns 7
Width of Columns 30
Dynamic Inserts Possible Yes
Unique ID Column LOCATION_ID
Structure Column None

Oracle Assets uses the location flexfield to group your assets by physical location. You design your location flexfield to record the information you want. Then you can report on your assets by location. You can also transfer assets that share location information as a group, such as when you move an office to a new location.

Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.

People Group Flexfield

The following table lists details for this key flexfield.

Owner Oracle Payroll
Flexfield Code GRP
Table Name PAY_PEOPLE_GROUPS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column PEOPLE_GROUP_ID
Structure Column ID_FLEX_NUM

The People Group flexfield lets you add your own key information to the Employee Assignment. You use each segment to define the different groups of employees which exist within your own enterprise. These may be groups which are not identified by your definitions of other Work Structures.

Personal Analysis Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code PEA
Table Name PER_ANALYSIS_CRITERIA
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column ANALYSIS_CRITERIA_ID
Structure Column ID_FLEX_NUM

The Personal Analysis Key Flexfield lets you add any number of Special Information Types for people. Each Special Information Type is defined as a separate flexfield structure for the Personal Analysis Flexfield.
Some common types of information you might want to hold are:

  • Qualifications
  • Language Skills
  • Medical Details
  • Performance Reviews
  • Training Records

Each structure can have up to 30 different segments of information.

Position Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code POS
Table Name PER_POSITION_DEFINITIONS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column POSITION_DEFINITION_ID
Structure Column ID_FLEX_NUM

Positions, like Jobs, are used to define employee roles within Oracle Human Resources. Like Jobs, a Position is an optional component of the Employee Assignment. However, unlike Jobs, a Position is defined within a single Organization and belongs to it.
Positions are independent of the employees who are assigned to those positions. You can record and report on information which is directly related to a specific position rather than to the employee.

Sales Orders

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MKTS
Table Name MTL_SALES_ORDERS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible Yes
Unique ID Column SALES_ORDER_ID
Structure Column None

The Sales Orders Flexfield is a key flexfield used by Oracle Inventory to uniquely identify sales order transactions Oracle Order Management interfaces to Oracle Inventory.
Your Sales Orders Flexfield should be defined as Order Number, Order Type, and Order Source. This combination guarantees each transaction to Inventory is unique.
You must define this flexfield before placing demand or making reservations in Oracle Order Management.

Sales Tax Location Flexfield

The following table lists details for this key flexfield.

Owner Oracle Receivables
Flexfield Code RLOC
Table Name AR_LOCATION_COMBINATIONS
Number of Columns 10
Width of Columns 22
Dynamic Inserts Possible Yes
Unique ID Column LOCATION_ID
Structure Column LOCATION_STRUCTURE_ID

The Sales Tax Location Flexfield is used to calculate tax based on different components of your customers’ shipping addresses for all addresses in your home country.

Oracle Service Item Flexfield

The following table lists details for this key flexfield.

Owner Oracle Service
Flexfield Code SERV
Table Name MTL_SYSTEM_ITEMS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column INVENTORY_ITEM_ID
Structure Column ORGANIZATION_ID

The Service Item flexfield uses the same table as the System Item Flexfield. However, you can set up your segments differently with the Service Item Flexfield.

Soft Coded KeyFlexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code SCL
Table Name HR_SOFT_CODING_KEYFLEX
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column SOFT_CODING_KEYFLEX_ID
Structure Column ID_FLEX_NUM

The Soft Coded KeyFlexfield holds legislation specific information. The Soft Coded KeyFlexfield structure that a user will see is determined by the legislation of the Business Group.
Localization teams determine the data that is held in this flexfield. Each localization team defines a flexfield structure and uses qualifiers to define the level at which each segment is visible. Segments can be seen at business group, payroll or assignment level. The type of information that is held in this key flexfield varies from legislation to legislation.
If you are using a legislation for which a Soft Coded KeyFlexfield structure has been defined you should not modify the predefined structure.

Stock Locators

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MTLL
Table Name MTL_ITEM_LOCATIONS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible Yes
Unique ID Column INVENTORY_LOCATION_ID
Structure Column ORGANIZATION_ID

You can use the Stock Locators Flexfield to capture more information about stock locators in inventory. If you do not have Oracle Inventory installed, or none of your items have locator control, it is not necessary to set up this flexfield.
If you keep track of specific locators such as aisle, row, bin indicators for your items, you need to configure your Stock Locators Flexfield and implement locator control in your organization.
This key flexfield supports only one structure.

System Items (Item Flexfield)

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MSTK
Table Name MTL_SYSTEM_ITEMS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column INVENTORY_ITEM_ID
Structure Column ORGANIZATION_ID

You can use the System Items Flexfield (also called the Item Flexfield) for recording and reporting your item information. You must design and configure your Item Flexfield before you can start defining items.
All Oracle E-Business Suite products that reference items share the Item Flexfield and support multiple-segment implementations. However, this flexfield supports only one structure.

Territory Flexfield

The following table lists details for this key flexfield.

Owner Oracle Receivables
Flexfield Code CT#
Table Name RA_TERRITORIES
Number of Columns 20
Width of Columns 25
Dynamic Inserts Possible Yes
Unique ID Column TERRITORY_ID
Structure Column None

You can use the Territory Flexfield for recording and customized reporting on your territory information. Territory Flexfields are also displayed in the Transaction Detail and Customer Detail reports in Oracle Receivables.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply