How to build an Application in oracle apps

Steps in Application Development:

1. Register your application.

2. Set up your application directory structures.

3. Modify the appropriate environment variable.

4. Create Oracle Id for customer application from SQL *plus.

5. Register new Oracle Id with the apps from Sys Admin responsibility.

6. Setting up a responsibility for Custom Application.

It requires setting of responsibility at

· Menu structure

· Data Group

· Report Group

7. Create new custom tables, views etc. through scripts and install the code in appropriate directory (like NEW-top/ install), and run the scripts.

8. Integrate your tables and views with the Oracle Applications APPS schema.

9. Register your tables and views that allow program, report or forms to use these objects.

10. Build your application libraries and forms.

11. Build your application functions and menus.

12. Build your application responsibilities.

13. Build concurrent programs and reports.

Set up your application directory structures

Create Oracle Id for customer application from SQL *plus.

Create user XXUSR identified by xxusr;

Setting up a responsibility for Custom Application

Responsibility:

Menu:

Data Group:

Request Group:

Create tables/procedures related to custom application in custom schema (user)

Create synonyms for all tables/views/procedures/packages of custom schema in Apps schema

Oracle Apps