Steps for Developing Custom Form in Oracle Apps

By | October 4, 2016

In this article of oracle hrms overview, you will find the steps for development of custom forms (using oracle developer suite 10g). This article covers the end to end process starting from developing a form and running on oracle apps. Custom form in oracle apps is developed based on TEMPLATE.FMB which is available in resources folder on application server. In order to find the steps for configuring TEMPLATE.FMB, See following article.

End to end process is given below in following article.

Table of contents

Create Form
Create Form Function
Attach to Menu
Migration of Custom Form Source File to Server
Compiling and Generating Compiled Files
Open the Form

Create Form

Through Application Developer Responsibility, Go to Form Function as shown below

Oracle HRMS Overview xy 1
Create a Form

Oracle HRMS Overview xy 2
Back to top

Create Form Function

Open following Function

Oracle HRMS Overview xy 3
Enter data in description tab as shown below

Oracle HRMS Overview xy 4

Enter data in properties tab as shown below

Oracle HRMS Overview xy 5

Enter data in forms tab as shown below

Oracle HRMS Overview xy 6
No action required for remaining tabs. Save the form.

Back to top

Attach to Menu

Through Application Developer, follow the following navigation

Oracle HRMS Overview xy 7

Enter the Function name in the last and save

Oracle HRMS Overview xy 8

Back to top

Migration of Custom Form Source File to Server

Once you finish the development of form in your local drive, Follow these steps to migrate the form in Oracle Apps.

Note: All Oracle forms source files (FMB files) are placed in AU_TOP Folder.

Connect to any file transfer tool e.g Winscp

Oracle HRMS Overview xy 9

Go to AU_TOP Folder

Oracle HRMS Overview xy 10

and copy the fmb file in forms/us folder in au top from your local drive

Oracle HRMS Overview xy 11

Now your source file is copied in your linux server

Oracle HRMS Overview xy 12

Back to top

Compiling and Generating Compiled Files

Following is the sample command for forms compilation. In your case you need to change the green portion of command (mentioned below) as per your installation directory paths. In this command, we have generated forms executable in PER_TOP folder.

frmcmp_batch module=/d01/oracle/VIS/apps/apps_st/appl/au/12.0.0/forms/US/XXLSG_HR_BUDGET_FORM.fmb userid=apps/apps output_file=/d01/oracle/VIS/apps/apps_st/appl/per/12.0.0/forms/US/XXLSG_HR_BUDGET_FORM.fmx

Connect to Putty

Oracle HRMS Overview xy 13

connect through your login

Oracle HRMS Overview xy 14

Simply paste the command

frmcmp_batch module=/d01/oracle/VIS/apps/apps_st/appl/au/12.0.0/forms/US/XXLSG_HR_BUDGET_FORM.fmb userid=apps/apps output_file=/d01/oracle/VIS/apps/apps_st/appl/per/12.0.0/forms/US/XXLSG_HR_BUDGET_FORM.fmx

Oracle HRMS Overview xy 15

Once the form is compiled successfully, it looks like this

Oracle HRMS Overview xy 16

and .fxm will be created in PER_TOP folder as shown below

Oracle HRMS Overview xy 17

Back to top

Open the Form

Since we have attached this form with AE HRMS Manager responsibility. So login with AEHRMS user

Oracle HRMS Overview xy 18

Click on AE HRMS Manager Responsibility

Oracle HRMS Overview xy 19

On right side you will see the link of LSG HR Budget. Click on it and you will see the following form.

Oracle HRMS Overview xy 20

After Data Entry form Looks like this

Oracle HRMS Overview xy 21

Note: Source and compiled files of this form is provided along with this manual so that learners can simply deploy this on their instance and start using this to practice a real time business requirement based assignment.

Back to top

If you have liked the contents in this post and you think it can be helpful to others, please share it at least once in your circle, in this way, you will join me in my cause to Learn Share and Grow. Come on, Lets Grow Together.

Related Posts

WISTU – Oracle Workflow Builder
Free Online Test
Solved Issued of Empty Email Notification
Steps for creating custom form in Oracle Apps
How to create backend logging mechanism
Useful Apps SQL Queries Pool
Top 10 Apps Technical Interview Questions