FND : fnd_descriptive_flexs, fnd_descr_flex_column_usages

The below tables are used to store the descriptive flexfield definition FND_DESCRIPTIVE_FLEXS stores setup information about descriptive flexfields. Each row includes the name of the table that contains the descriptive flexfield columns, the name and title of the flexfield, the identifier of the application with which the flexfield is registered, whether the flexfield is currently … Read more


FND_CONCURRENT_PROGRAMS stores information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program (EXECUTION_METHOD_CODE), the argument method (ARGUMENT_METHOD_CODE), and whether the program is constrained (QUEUE_METHOD_CODE). If the program is a special concurrent program that controls the concurrent managers, QUEUE_CONTROL_FLAG is set … Read more

Oracle Concurrent Requests : FND_CONCURRENT_REQUESTS

FND_CONCURRENT_REQUESTS stores information about individual concurrent requests. Each row includes values that identify the particular request and its parameters, such as who submitted it, the request type, whether the request should run sequentially with other requests in the same logical database (SINGLE_THREAD_FLAG), whether the request is on hold (HOLD_FLAG), whether to display the request in … Read more

Oracle concurrent programs table: FND_EXECUTABLES

FND_EXECUTABLES stores information about concurrent program executables. Each row includes an application identifier, an executable identifier, an executable name, and the name of the physical executable file as it resides on the operating system. The execution method associated with the executable identifies the tool that is needed to run the executable. A subroutine name is … Read more


FND_FLEX_VALUE_NORM_HIERARCHY stores information about multi–level value hierarchies for independent and dependent value sets. Each row includes a value set name, a parent value, a flag to distinguish a child value from a parent value (RANGE_ATTRIBUTE), a low value for the range of child values, and a high value for the range of child values. Oracle … Read more


FND_FLEX_VALUE_SETS stores information about the value sets used by both key and descriptive flexfields. Each row includes the application identifier, the name and description of the value set, the validation type of value set (F for Table, I for Independent, D for Dependent, N for None, P for Pair, U for Special), the data format … Read more


WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders. A process activity is a modelled workflow process, which can be included as an activity in other processes to represent a sub–process. A notification activity sends a message to a performer. A functions activity performs an automated function that … Read more

Oracle FND key tables , FND_FLEX_VALUE_HIERARCHIES (4)

FND_FLEX_VALUE_HIERARCHIES stores information about child value ranges for key flexfield segment values. Each row includes an identification of the parent value the range belongs to, as well as the low and high values that make up the range of child values. FLEX_VALUE_SET_ID identifies the value set to which the parent value belongs. You need one … Read more

Oracle FND key tables , FND_FLEX_VALUES (3)

FND_FLEX_VALUES stores valid values for key and descriptive flexfield segments. Oracle Application Object Library uses this table when users define values for independent or dependent type value sets. Oracle Application Object Library also uses this table when users define parent values for ranges of child values that exist in a validation table (Oracle Application Object … Read more