Question

what are the steps to develop the NEW MODULE DEVELOPMENT in oracle Apps?

Answer 1

Steps Required for Developing a New Module

1. Register the New Module with AOL Module.

Save the Entries

2. Create a Schema/User for the New Module and Grant Roles to it from SQL Prompt.

Login as apps/apps@vis.
SQL>CREATE USER PPRS IDENTIFIED BY PPRS;
SQL>GRANT CONNECT, RESOURCE TO PPRS;
SQL>

3. Create Product Directory Structure to the New Module at Server end.

\Orafin8\d$\appl\pprs\12.1.1\forms\us
\Orafin8\d$\appl\pprs\12.1.1\reports\us
\Orafin8\d$\appl\pprs\12.1.1\bin
\Orafin8\d$\appl\pprs\12.1.1\sql etc,

4. Create the Form Using Form Builder with all the coding standards required according to Oracle Application.

5. Compile the Form and copy .FMX file in Module Specific (New) Directory.

6. Copy some .fmx Form files from any existing modules to new module directory for registration demo.

7. Register the form with Application Object Library (AOL) mODULE.

Connect to APPSTECH/APPSTECH
Go to Application Developer
Save and Close

8. Create Form Function for all the Forms which are Registered with our Module

Connect to APPSTECH/APPSTECH
Go to Application Developer
. Application
. Function
Save and Close

9. Define a menu for our new module using AOL Module.

Connect to APPSTECH/APPSTECH
Go to Application Developer
. Application
. Menu

10. Assign the required Form Functions to the Menus.

11. Define Data Group (DG) using System Administration Module.

System Adminstrator
Security
Oracle
Data Group

12. Define a Responsibility for the New Module.

System Administrator
Security
Responsibility
Define

Assign Responsibility to the User.
System Administrator
Security
User
Define

14. Setup the base path of the New Module at the server end.

PPRS_TOP is the base path
At Run : regedit
Create New String
Rename the New String as PPRS_TOP
PPRS_TOP : \Oracle\visappl\pprs\12.1.1