Manage Tables
In the Noetix Views Workbench (NoetixViews Workbench), you can add a table or view to one or more queries of the view. You can also modify the properties of a table or view.
You can add tables or views corresponding to the custom Oracle E-Business Suite applications to the definition of a view during the following tasks:
Addition of a view
Modification of an existing view
Addition of a lookup column
- Modification of a lookup column
The following topics explain the procedures related to managing tables:
You can manage tables and Noetix views corresponding to custom Oracle E-Business Suite applications or applications that are not enabled if they have been fully defined and integrated with the suite. However, Oracle views created for the standard or custom Oracle E-Business Suite applications are not supported in the NoetixViews Workbench. A fully defined application must have the associated records in the following tables:
APPLSYS.FND APPLICATION
APPLSYS.FND APPLICATION TL
APPLSYS.FND PRODUCT INSTALLATIONS
- APPLSYS.FND ORACLE USERID
For information about how to create and register custom Oracle E-Business Suite applications, see the Oracle E-Business Suite documentation.