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.

Register your application


 Set up your application directory structures


Create Oracle Id for customer application from SQL *plus.
        Create user XXUSR identified by xxusr;

Register new Oracle Id with the apps from Sys Admin responsibility


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
Register the required table/views/sequence in apps.