Summary

Technical Aspect



Let’s look at some of the important tables in AOL. Although a lot of the tables are discussed in other chapters of the book, as they are related to the FND application, we will look for some of the very important and frequently used tables.



Note: 


  • In the table below, if the Date tracked column is marked as Yes, assume the Primary key to be Composite. The given Primary with bind with the two date tracked columns to make the Composite Primary key.
  • Some of the values in the column Table could be a view / synonym. However they pull data.

 

 Table Name

 Date Tracked?

 Description

FND_ID_FLEXS

 

Stores the KFF Register Data

FND_ID_FLEX_STRUCTURES

 

Stores Data related to KFF Definitions

FND_ID_FLEX_SEGMENTS

 

Stores the KFF Segments

FND_DESCRIPTIVE_FLEXS

 

Stores the DFF Register Data

FND_DESCR_FLEX_CONTEXTS

 

Stores DFF Contexts

FND_DESCR_FLEX_COL_USAGE

 

Stores DFF Attribute Details

FND_FLEX_VALUE_SETS

 

Stores the value set Definitions

FND_FLEX_VALIDATION_TABLES

 

Stores the Table type value set details.

FND_NEW_MESSAGES

 

Stores Message Details

FND_CONCURRENT_PROGRAMS

 

Stores the Concurrent Programs

FND_EXECUTABLES

 

Stores the Concurrent Program Executables.


Summary



In this chapter, we learnt about the Flex fields. We discussed about the Descriptive and Key flex fields, and their usages. We learnt how to define the flex fields. We discussed about the different expedient ways to store frequently used data in Oracle E-Biz, using Lookups and User Defined Tables. We also discussed about value sets, their usages and the required setups. We learnt about the Messages. Then we moved on to Concurrent Programs, and we learnt how to set one up.