When working with offline database definitions in JDeveloper, you can design the database model for your custom objects. These objects are stored as XML files, but can at any point in time be synchronized into the database schema, so as to deploy the objects to the database. You can convert offline database definitions to live database connections to create, alter, or drop database objects.
JDeveloper provides offline database tool to create and edit database objects such as tables and constraints outside the context of a database. When your Fusion Applications custom project is complete, the entire ADF Artifcats alongwith the custom DB components in offline DB can be deployed to UAT or the production instance.
For example
You can create new tables and views and generate the information to a database.
You can create new tables and views and generate the information to a file, which you can edit and later run on a database connection.
Conversely, you can also import tables and views from a database schema, make the changes you want and then generate the changes back to the same database schema, to a new database schema, or to a file that you can run against a database at a later date. JDeveloper allows you to manually reconcile changes before committing them to a database.
You can use the modeling tools in JDeveloper to visualize your offline database objects on a diagram.
In this article you will see the steps for building the offline database.
Ideally, you should have installed the JDeveloper as per the instructions in this link
http://apps2fusion.com/component/content/article/69-adf/517-fod-schema-adf-jdeveloper-ant
Comments
(2)
Subscribe to this comment's feed
breitling navitimer world replica
written by breitling navitimer world replica , September 19, 2012
written by breitling navitimer world replica , September 19, 2012
breitling navitimer world replica
I have no expectations because it's better to be surprised than disappointed?
Votes: +0
I have no expectations because it's better to be surprised than disappointed?
report abuse
vote down
vote up
One doubt, I have R12.1.3 application. My requirement is to invoke the ADF screens from Ebiz R12.1.3 screen and vice versa. How can i achieve it?. Any specific setup needs to be done?
Regards,Soorya