Saturday, July 6, 2013

How to Create a Custom Form Menu Function / Item in Oracle Applications:

How to Create a Custom Form Menu Function in Oracle Applications
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
How to Create a Custom Form Menu Function in Oracle Applications [ID 133993.1]

Note: The following steps will use the form name example of RUNRPT.
-----
1. Log into the Sysadmin responsibility.

2. Navigate to Application > Function.

3. Enter a unique function name under the "Function" column.

Ex: MY_RUNRPT

4. Enter a unique name under the "User Function Name" column.

Ex: My RUNRPT Function

5. Enter the word FORM under the "Type" column.

6. Enter a description under the "Description" column.

7. Select the "Form" tab from the drop down menu.

8. Enter the form name using the list of values button on the toolbar or the "Edit" > "List of Values" menu option to query up the custom form name.

9. Save.

++++++++++++++++++++++++++++++++++++++++++++++++++++++
How to Add a Custom Menu Item in Oracle Applications [ID 133992.1]
+++++++++++++++++++++++++++++++++++++++++++++++++++++++

1. Log in to the GUI Sysadmin responsibility
  2. Locate the name of the menu for which the menu item is to be added.
       1.Navigate to Security > Responsibility > Define
       2.The name is located in the menu field
       3.For the System Administrator responsibility this is: Navigator Menu -
          System Administrator GUI
  3. Query up the Menu and add either a Submenu or the new menu function
       1.Navigate to Application > Menu and use the flashlight or Find menu
         function to bring up the menu
       2.For System Administrator this is: FND_NAVIGATE4.0
       3.See Note:133993.1 How to Create a Custom Form Menu Function
         in Oracle Applications           
+++++++++++++++++++++++++++++++++++++++++++++++++++++
How to Register a Custom Form in Oracle Applications [ID 133995.1]
+++++++++++++++++++++++++++++++++++++++++++++++++++++
To Register a custom form in Oracle Applications, take the following steps.

(As practice, copy the form FNDRSRUN.fmx under the $FND_TOP/forms to a file
called RUNRPT.fmx. The form RUNRPT.fmx will now be used in the following steps.)

1. Log into the Applications Developer responsibility.

2. Navigate to Application > Form.

3. Enter the form name under the "Form" column: RUNRPT

4 Enter the Application under the "Application" column using the list of value
  button, or the "List of Values" function under the "Edit" menu option:

     Application Object Library

5. Enter a name for the form under the "User Form Name" column:

     My Report Run Form

6. Enter a description for the form under the "Description" column:

     Custom Report Run Form

7. Save.
++++++++++++++++++++++++++++++++++++++++++++++++++++++
How to Register a Custom Report [ID 133991.1]
++++++++++++++++++++++++++++++++++++++
1.Login to the System Administrator responsibility.
2.Navigate to: Concurrent > Program > Executable
3.Fill out the form similar to the following:
   Executable: CUSTOM
   Short Name: CUSTOM
   Application: Application Object Library
   Description: My Custom Program
   Execution Method: Oracle Reports
   Execution File Name: CUSTOM
4.Save         
5.Navigate to: Concurrent > Program > Define
6.Fill out the form similar to the following:
   Program: My Custom Report
   Short Name: CUSTOM
   Application: Application Object Library
   Description: My custom report
   Executable:
        Name: CUSTOM
        Method: Oracle Reports
   Request:
        Use in SRS
        Restart on System Failure
   Output:
        Format: Text
        Save
        Print
        Columns: 132
        Rows: 45
        Style: Landscape
7.Save
8.Locate the Request Group name.
   a. Login to Sysadmin responsibility.
   b. Navigate to Security > Responsibility > Define
   c. Query up Responsibility.
   d. Request group is located in Request Group > Name frame.
9.Navigate to Security > Responsibility > Request
10.Query up the group of the responsibility that will run the report.
11.Add the report under the "Requests" frame as a Program; the report can queried using
     the Query > Find menu option or by clicking the Flashlight button on the Toolbar.
12.The report can now be run via the responsibility associated with the request group.
+++++++++++++++++++++++++++++++++++++

                Forms Customization [ID 69995.1]

No comments:

Post a Comment