Oracle Security

In this, we will discuss how we can control the particular set of screens,reports,programs access to set of people in Apps,for example, only General Ledger team should have access to entering journals,posting etc.

Register Application ( This is required if you going to have brand new custom application,if you are going to have one or two screens then this step is not needed)

Application Developer Responsibility ->Application-> Register Register forms


Register forms
Application Developer Responsibility ->Application-> Forms


Fields
Form : Enter the file name of your form (the name of the .fmx file) without extension. Your form filename must be all uppercase, and its .fmx file must be located in your application directory structure.

Application : Enter the name of the application which will own this form.

User Form Name : This is the form name you see when selecting a form using the Functions window.

Description : Enter a suitable description for your form.

Register functions

Application Developer Responsibility ->Application->Function

Fields
Function : Enter a unique function name for your function. This function name can be used while calling this program programmatically. This name is not visible to the user through other forms.

Form : Select the form name which you have registered.

Application : Select the application name for your form.

Parameters : Enter the parameters that you want to pass to your form function. E.g. Query_only.

Register Menu and sub-menus
Application Developer Responsibility ->Application->Menu

Fields
Menu : Enter the descriptive name for the menu. This name is not visible to the user.
User Menu Name : The user menu name is used when a responsibility calls a menu.
Menu Type : The options in menu type include:
· Standard - for menus that would be used in the Navigator form
· Tab - for menus used in self-service applications tabs
· Security - for menus that are used to aggregate functions for data security or specific function security purposes, but would not be used in the Navigator form
Seq : Enter a sequence number.
Prompt : Enter the prompt that the users will see for the menu.
Submenu : If you want another menu to be called from this menu, then enter this menu name in this field.
Function : Enter the form function name in this field.
Description : Enter a suitable description for the menu.
Grant :The Grant check box should usually be checked. Checking this box indicates that this function is automatically enabled for the user.