Zoom Functionality through Forms Personalization

By | September 25, 2016

Table of Contents

Business Requirement
Solution Concept
Find the form name to be called
Create Source Form’s Personalization
Create Personalization in Destination Form
Test the Forms Personalization

Business Requirement

It is a very common requirement to open a form from another form to see any further details of parent form. In this example we have selected similar business requirement in which we want to see the details of executable from concurrent program screen

Back to top

Solution Concept

Above mentioned requirement can be fulfilled by personalization. Personalization can be achieved either by using custom.pll or by using forms personalization. This document addresses the solution using forms personalization. For personalization using custom.pll, please refer our other solution named Personalization through custom.pll.
For Personalization using Oracle Forms Personalization, following are high level steps.
• Find the form name to be called
• Personalize Source form
• Personalize Destination form
• Test the Forms Personalization

Back to top

Find the form name to be called

Switch to System Administrator Responsibility

Oracle HRMS overview hr 1

Through System Administrator responsibility, open the Executable Form. Following is the navigation path as shown in the figure below

Oracle HRMS Overview hr 2

Click on Help->About Oracle Applications

Oracle HRMS Overview hr 3

From the current form section, Note down the Form Name. This is form that we shall call from concurrent program. As shown from figure below, we can notice its name is FNDCPMPE

Oracle HRMS Overview hr 4

Now go to Application Developer Responsibility and open the Form Screen through following navigation

Oracle HRMS Overview hr 5

and find the user form name ‘ Define Concurrent Program Executable

Oracle HRMS Overview hr 6

After this go to following navigation in same Application Developer Responsibility

Oracle HRMS Overview hr 7

and Query the User Form Name to find Form Function

Oracle HRMS Overview hr 8

Following result will be displayed

Oracle HRMS Overview hr 9

From above screen, we have reached to Form function that we shall be using in the forms personalization to call the Executable screen

Back to top

Create Source Form Personalization

Through System Administrator Responsibility, go to following navigation

Oracle HRMS Overview hr 10

Following form will be opened

Oracle HRMS Overview hr 11

Open the Menu Option shown below

Oracle HRMS Overview hr 12

Provide the Apps Password, It is necessary to provide apps password for forms personalization

Oracle HRMS Overview hr 13

Following screen will be opened

Oracle HRMS Overview hr 14

Create a record in header section with sequence 10 and description as Create Menu Entry.

Oracle HRMS Overview hr 15

Click on Actions tab and Create an action to create a menu item

Oracle HRMS Overview hr 16

Save it. Note that Menu Entry is MENU1. In next step, we need to catch the event against this menu item.

Create another record in Header section with sequence 15 as ‘Create and Set Global Variable’.
In the Condition tab, select MENU1 as triggering event.

Oracle HRMS Overview hr 17

Now create action to set the global variable as shown below

Oracle HRMS Overview hr 18

Now create action item with sequence 15 to assign the executable name in global variable as shown below

Oracle HRMS Overview hr 19

Now create action item with sequence 20 to open executable form. Please note that here we have used the form function (FND_FNDCPCME) name that we had identified in step above

Oracle HRMS Overview hr 20

Back to top

Create Personalization in Destination Form

Open the executable form and go to personalization screen through following menu option as shown below

Oracle HRMS Overview hr 21

Create a rule with sequence 10 and condition should be to check if global variable contains some value then only this personalization should work. Therefore in the condition tab, we are checking the value of global variable

Oracle HRMS Overview hr 22

Once record is save and go to Actions Tab

Create action with sequence 5 as shown below

Oracle HRMS Overview hr 23

Create Action Item to set the default where clause of executable block. Following is the syntax to set the where clause.

=’EXECUTABLE_NAME=NVL(:GLOBAL.GLB_EXECUTABLE,EXECUTABLE_NAME)’

Oracle HRMS Overview hr 24

Create action item with sequence 15 to execute query

Oracle HRMS Overview hr 25

Create action item to reset the global variable value to NULL

Oracle HRMS Overview hr 26

Note: Delete Action No 5, No need of it

Final Records of Personalization will look like this

Oracle HRMS Overview hr 27

Back to top

Test the Forms Personalization

From System Administrator Responsibility, Go to Concurrent Program Screen. Find any concurrent program. Now you notice, there is menu option of ‘LSG Call Executable’ available under Tools Menu. click on it

Oracle HRMS Overview hr 28

It will open the following form that contain the executable details of concurrent program

Oracle HRMS Overview hr 29

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