In Oracle : Oracle Apps Flex Fields in 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle Apps Flex Fields in 11i

 

 Oracle Apps Flex Fields in 11i

 

 

1. What is a flexfield ?

2. What is a value set ?

3. Which are the 2 types of Flexfields ?

4. How could I see which KFFs I have registered in the database?

5. Which are the steeps in creating a KFF layout ?

 

 

1. What is a flexfield ?

 

The values for items are kept in segments. The segments could be combined logically in groups called structures. One flexfield contains one or more structures.  

2. What is a value set ?

 

A value set is a set of values or a range of values a segment could get values from. 

 

 

3. Which are the 2 types of Flexfields ?

 

The 2 types of flexfields are: 

  • Key Flexfields (KFFs): Are used as identifiers of entities. 

  • Descriptive Flexfields (DFFs): Are used for gathering more information about the Oracle Apps entities. 

 

The DFFs are:

- optional

- enclosed in brackets

- in contrast to the KFF, are not shared between applications

 

 

4. How could I see which KFFs I have registered in the database ?

 

 

If you want to see which KFFs you have registered in the database and the tables which store they code combinations you could run the following SELECT:

 

SELECT id_flex_name, application_table_name FROM apps.fnd_id_flexs order by application_id;

 

Example:

 

SQL> SELECT id_flex_name, application_table_name FROM apps.fnd_id_flexs order by application_id;

ID_FLEX_NAME                         APPLICATION_TABLE_NAME
------------------------------         ------------------------------
Accounting Flexfield                       GL_CODE_COMBINATIONS
Reporting Attributes:Accountin       GL_CODE_COMBINATIONS
Category Flexfield                          FA_CATEGORIES_B
Asset Key Flexfield                        FA_ASSET_KEYWORDS
Location Flexfield                           FA_LOCATIONS
Oracle Service Item Flexfield          MTL_SYSTEM_ITEMS_B
ARTA-Receipt Prof Ident              AR_TA_PROF_ASSGNT_ALL
Territory Flexfield                           RA_TERRITORIES
Sales Tax Location Flexfield           AR_LOCATION_COMBINATIONS
Item Categories                              MTL_CATEGORIES_B
Account Aliases                              MTL_GENERIC_DISPOSITIONS

 

 

5. Which are the steeps in creating a KFF layout ?

 

- identify the structure title

- plan the number and order of segments

- identify the value sets to be used

- choose the segments prompts

- determine which segments are displayed or not

- establish relationships between segments

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Oracle Apps Flex Fields in 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.