Table of Contents
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
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
Find the form name to be called
Switch to System Administrator Responsibility
Through System Administrator responsibility, open the Executable Form. Following is the navigation path as shown in the figure below
Click on Help->About Oracle Applications
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
Now go to Application Developer Responsibility and open the Form Screen through following navigation
and find the user form name ‘ Define Concurrent Program Executable
After this go to following navigation in same Application Developer Responsibility
and Query the User Form Name to find Form Function
Following result will be displayed
From above screen, we have reached to Form function that we shall be using in the forms personalization to call the Executable screen
Create Source Form Personalization
Through System Administrator Responsibility, go to following navigation
Following form will be opened
Open the Menu Option shown below
Provide the Apps Password, It is necessary to provide apps password for forms personalization
Following screen will be opened
Create a record in header section with sequence 10 and description as Create Menu Entry.
Click on Actions tab and Create an action to create a menu item
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.
Now create action to set the global variable as shown below
Now create action item with sequence 15 to assign the executable name in global variable as shown below
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
Create Personalization in Destination Form
Open the executable form and go to personalization screen through following menu option as shown below
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
Once record is save and go to Actions Tab
Create action with sequence 5 as shown below
Create Action Item to set the default where clause of executable block. Following is the syntax to set the where clause.
Create action item with sequence 15 to execute query
Create action item to reset the global variable value to NULL
Note: Delete Action No 5, No need of it
Final Records of Personalization will look like this
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
It will open the following form that contain the executable details of concurrent program
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.
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