Similarity between Database Objects and ADF Business Components

Oracle ADF is an Application development framework for Rapid Application Development. Oracle ADF uses Business components in the Model Layer to perform the transactions. ADF Business components are similar to Database Objects.

Suppose we have to create a database to store Department and Employee data in the database. For this, we will have to create two tables DEPARTMENTS and EMPLOYEES where DEPARTMENTS will be a master and EMPLOYEES will be detail table.

For the above scenario, we will have to do the following in the database.

1. Create table DEPARTMENTS.
2. Create table EMPLOYEES.
3. Create a Foreign Key between DEPARTMENTS and EMPLOYEES to establish a master-detail relationship.
4. SQL Query to perform DML operations i.e Create, Read, Update and Delete operations.

 If we have to create an ADF application for viewing and updating the above database structure then the following Business Objects will be created.

1. Entity Object "DepartmentsEO" to represent the DEPARTMENTS Table.
2. Entity Object "EmployeesEO" to represent the "EMPLOYEES" Table.
3. Association "DeptToEmpAS" to represent the Foreign Key relationship.
4. ViewObject "DepartmentsVO" and "EmployeeVO" to represent the SQL queries to represent DEPARTMENTS and EMPLOYEES tables respectively.

 In short, we can understand the similarity with the image below.

ADF | Line 1 column 18. When does this error comes up.

Error Description: Line 1 column 18

Cause: This error comes up when we call a database function from the ADF Application and that database function is uncompiled. The function may be uncompiled due to some error in the database function.

Corrective Action: You just have to open the database function and fix the error in the database function. Once the function is compiled this error will not appear again.