How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

 How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

Introduction
In Oracle E-Business Suite, it is a common requirement to call a seeded (standard) Oracle form from a custom-developed form and pass values automatically.

This blog explains how to:

• Call a seeded form using FND_FUNCTION.EXECUTE
• Pass values using Global Variables
• Use Form Personalization to auto-populate fields

Business Requirement
From a custom form, users want to:

• Click a button (e.g., “Call Release Sales Order Form”)
• Open the standard Release Sales Order form
• Automatically pass:
• Order Number
• Picking Rule

Step 1: Create Button in Custom Form

In your custom form, create a button like:
CALL_FORM

Add a trigger:
👉 WHEN-BUTTON-PRESSED

Step 2: Write Code in Trigger

BEGIN

    -- Assign values to Global Variables

   :GLOBAL.G_ORDER_NO    := :BLOCK.ORDER_NUMBER;

   :GLOBAL.G_PICKING_RULE := :BLOCK.PICKING_RULE;

    -- Call Seeded Form

   FND_FUNCTION.EXECUTE

   (

      FUNCTION_NAME => 'WSH_WSHFRREL',

      OPEN_FLAG     => 'Y',

      SESSION_FLAG  => 'Y'

   );

 END;

Step 3: What Happens Here?

• Values from custom form fields are stored in Global Variables
• Seeded form is opened using FND_FUNCTION.EXECUTE
• Global variables act as a bridge between forms

 

Step 4: Form Personalization in Seeded Form

Navigate to:

Help → Diagnostics → Custom Code → Personalize

In function: WSH_WSHFRREL

Add actions:

 

Action 1: Set Picking Rule

• Object Type: Item
• Target Object: RELEASE.PICKING_RULE
• Property Name: VALUE
• Value::GLOBAL.G_PICKING_RULE

 

Action 2: Set Order Number

• Object Type: Item
• Target Object: RELEASE.ORDER_NUMBER
• Property Name: VALUE
• Value::GLOBAL.G_ORDER_NO

 

Step 5: Result

When the user clicks the button:

• Seeded form opens automatically
• Order Number and Picking Rule are auto-filled
• No manual input required

 

Advantages

• Saves user time
• Reduces manual errors
• Seamless integration between custom and standard forms

 

Best Practices

• Always clear global variables if not required later
• Use meaningful variable names
• Add validations before calling seeded form

 

Conclusion
Using FND_FUNCTION.EXECUTE along with Global Variables and Form Personalization is a powerful way to integrate custom forms with standard Oracle forms. This approach improves usability and ensures smooth data flow across modules.