Essentials

 Responsibility
 Menu
 Request Group
 Run request (Report Or Procedure) :- 1- Menu > View > Requests > Submit New Request >>
 Single Request
 Request Set (More Than One Request) .
2- Choose Report Name .
3- Define Parameters.
4- Submit (Copy Button displays lov contains the last requests you run) .
5- Find.

-----------------------------------------------------------------------------------------------------------------------------------------------

 Create User :- Responsibility (System Administrator) > Security > User > Define
1- Enter user name
2- Enter the password and re-enter the password in the same item.
3- Select Person (The employee that the user refers to or related to this user).
4- You can expire the password after N (Number) Days or accesses.
5- You can deactivate the user on a specific date by inserting the wanted date in (Effective dates From & To) .
 Create Responsibility :- Responsibility (System Administrator) > Security > Responsibility > Define
1- Enter responsibility name (Unique with application name).
2- Enter responsibility key (Unique in application).
3- Select a Menu & Data group & Request Group.
 You can create responsibility as a copy from another one (global HRMS manager).
 Assign the responsibility to the user.
 Create Request Group :- Responsibility (System Administrator) > Security > Responsibility > Request

User
Responsibilty 1 Responsibilty 2

Menu Request Group

---------------------------------------------------------------------

 Create Menu := Responsibility (System Administrator or Application Developer) > Application > Menu
1- Enter Menu: - The technical name that is be used in code.
2- User Menu Name: - The name Appears in the application.
 Suppose that you want to create a menu with two submenus (Forms &Reports) and every submenu has two nodes.

Forms
Form 1
Form 2
Report
s
Report 1
Report 2
1- Create menu 1 (FORMS_MENU) and define under it two details (form 1 &Form 2) , Every detail call a function .
2- Create menu 2 (REPORTS_MENU) and define under it two details (Report 1 &Report 2) , Every detail call a function .
3- Create menu 3 (MASTER_MENU) and define under it two details (Forms &Reports) , Every detail call a submenu
(The two previous menus) .
Function Ex. (Enter Adjustments & Enter And Maintain & Person Activitie & Define Payroll) .
 4- Assign the 3rd menu to the responsibility.
 How to know user function name: - Transfer the form to the “Top Ten List” and the name appears is the user function
name.
 How to know technical function name: - Responsibility (Application Developer) > Application > function and search with
“user function name”, the technical function name appears in item function.
 In Function window you can go to form tab and know user form name.
 You can use user form name and know FMX name by searching in Application Developer > Application > Form
with user form name.
 Flexfields :-
1- Descriptive Flexfields := Additional fields for additional data and saved in the database in additional columns called
“Attributes” .
2- Key Flexfields := fields necessary for any module.
 Implement Flexfields :-
1- You can know descriptive name by clicking it’s sign on the form, it appears as a title of the window opened or from
menu Help > Diagnostics > Examine > choose descriptive block then descriptive filed and it’s values will appear .
2- Responsibility (System Administrator) > Application > Flexfield > Descriptive > Segments, Search with descriptive
name in Title item.
3- Uncheck Freeze checkbox to enable update.
4- Check Displayed checkbox to show all descriptive or uncheck it to show global data descriptive only.
5- Open Segments window to define the new fields and it’s database columns.
6- In Segments window you can click Open button to assign more attributes to new segment.
 Business case :- Show two descriptive ,The first contains wife name if employee gender is male, The second contains
husband name if employee gender is female .
1- Define the filed name (SEX in this case) in item reference field .
2- Add new descriptive with code as the same as field value (Female => F & Male=>M) .
3- In each descriptive define the segments you want to appear with it.
4- When Displayed checkbox is unchecked, only global descriptive and descriptive references a field appears.
 Value Set :- control the value will be inserted into the attribute (Date , Number , Char , Format , using LOV,,,,,) .
 FND_STANDARD_DATE is a built in value set used for date.
 Responsibility (System Administrator or Application Developer) > Application > Validation >
Set to define the value set
OR Values to insert it’s values .
 Define Value Set Name & Format Type(date , number ,Char) & Maximum Size.
 Set item Validation Type to None if the value is not specified .
 Set item Validation Type to Independent and set item List Type to List Of Values if the value is selected from
static list .
 Define the static list elements in Responsibility (System Administrator or Application Developer) > Application >
Validation > Values , choose the defined value set then press button find and insert it’s elements.
 If you created a value set with Validation Type( Dependent) , the button Edit Information will be enabled to
choose which value set is the reference .
 Press this button and select the Independent value set and enter any values as default.
 From Responsibility (System Administrator or Application Developer) > Application > Validation > Values ,
choose the defined dependent value set , then select each value of Independent value set then press button fine and
insert the related elements.
 You can create a value set with Validation Type ( Table) to get dynamic data from database.
 Press button Edit Information to define Table Name (table or view or select statement between brackets) for
example (HR_ORGANIZATION_UNITS) .
 In Table columns sections define Value => first column appears in LOV & Meaning => second column appears in
LOV & Id => the value will be set into database (name & Date_from & organization_id) .
 You can add Where/Order By clause (order by organization_id) .
 You can add additional column in the LOV appears by inserting column name in item Additional Columns but you
should alias it between double quotation (Date_from “Date From”) .
 You can create a value set depends on a value of another value set with dynamic values ,
Suppose that the first value set (Organization_vs) returns Organization_id and the second value set
(Employees_vs) will return the employees in the selected Organization , To do that you should add
where column = :$FLEX$.Value Set Name(where Organization_id = :$FLEX$.Organization_vs).
 Profiles :- Block contains global values such as (user id , user name , responsibility) and other values that you can know
from Help > Diagnostics > Examine > choose block $Profiles$ , you can use it’s values as : $Profiles$.user_id .
 You can get values from profiles by using Fnd_profile.value(‘user_id’) Or Fnd_global.user_id .
 You can use profiles to set default value to a segment by assigning values( Profile Or SQL Statement) to item
Default Type and assigning (User_id Or select Fnd_global.user_id from dual) to item Default Value .
 Profile Options :- System General setting that affect application at user scope or responsibility or all site from
Responsibility (System Administrator) > Profile > System
 Choose responsibilty or user and choose the profile then press button Find to assign a values for it .
 HR:Query Only Mode to control system mode .
 Signon Password Length to control password length.
 Java Color Scheme to control scheme color .
 Site Name to control the title of appliaction main window .