For this example I have an ADF application with model project and I want to create one new Entity Object in the model project:
- Right click on the Model Project --> New --> Entity Object
- You will find there is no Database Schema and You can't Browse schema object.
- In the Model project if you check if there is a database connection is defined in ADF Business Components or not, you will find there is a database connection defined.
So where is the problem?
Let us try to create the entity using Business Components From Table
You will find in the third step, there is no schema and you can't shuttle anything and the wizard will stop in this step as shown:
The reason of this issue come from the database user privileges. To fix this issue follow the following steps:
1- Connect to sys database and grant dba to the database user which you use in ADF application Model.
2- Restart Jdeveloper.
3- Now try to create new Entity or Create Business Component From Table, it should be ok and works fine.