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.

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.