Customizing Forms in Oracle HRMS
We get the requirements for restricting access and fuctionalites in form which is normally done either by formspersonalization or custom.pll or standard form modification
In HRMS quite often i have seen the restrictions like create applicant ,create placment ,create employement functionalities to certain responsibilities…For these forms there is no need to do forms personalization …because oracle have developed these forms in a architecture to allow common customisations by doing setup..
1.Custom form functionality
2.Task Flows..
First let us look at the custom Form Functionality..
For example
For some responsibility I want to allow the user to create Employees, Contingent workers and Other but not Applicants..Lets see how implement this requirement
1: Define custom form
Responsibility: Global HR Manager (or alike)
Navigation : Security > CustomFormSelect ‘Combined Person & Assignment Form’
as Form to be customized
Give your custom form a unique name and titles.
SaveRestrictions
Type: Restrict by person action
Value: Create employmentAdd any actions you want to have enabled on the form.
2. Define form function that uses this custom function
Responsibility: System AdministratorNavigation: Application > functionCreate a new form functionType: FormForm: Combined Person & Assignment FormParameters: HR_CUSTOMIZATION=”xx_your_custom_form” in our case it will beHR_CUSTOMIZATION=”CREATE ACTION”
3. Add this new function in your menuResponsibility: System Administrator
Navigation: Application > menuQuery the menu your responsibility is using and replace the existing function with the newly created custom function.
Please note that HR_CUSTOMIZATION parameter does not work in conjunction with WORKFLOW_NAME (Task Flow)parameter
sir
could you help me in solving the issue of invalid number during runtime while running this form. the query in which the error is
BEGIN
SELECT to_number(max(PEEVF.SCREEN_ENTRY_VALUE))
into :P_TRANS_AMT
FROM PER_ALL_PEOPLE_F PAPF,
PER_ALL_ASSIGNMENTS_F PAAF,
PAY_ELEMENT_ENTRIES_F PEEF,
PAY_ELEMENT_ENTRY_VALUES_F PEEVF
where papf.person_id = :PERSON_ID
and papf.person_id = paaf.person_id
and paaf.assignment_id = peef.assignment_id
and peef.element_entry_id = peevf.element_entry_id
and peef.element_type_id = 148
and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
and trunc(sysdate) between peevf.effective_start_date and peevf.effective_end_date;
EXCEPTION WHEN NO_DATA_FOUND THEN
:P_TRANS_AMT := 0;
END;
thanks
Hi,
I have checked. Query is working fine at my end.
Regards,
Faisal
Assalamualaikum
thanks for your reply
i want a function or query to convert a number to arabic numbers even the number is in the form as 2-3445-4244-1.
regards
syed zubair
Very informative post, i am regular reader of your website.
I noticed that your site is outranked by many other blogs in google’s search results.
You deserve to be in top10. I know what can help you, search in google for:
Omond’s tips outsource the work