Sunday Jul 15, 2012

Oracle iRecruitment vacancy Segregation Full Solution

This document describes the detailed steps for implementing Vacancy segregation in Oracle iRecruitment. The solution is configurable and can be very easily rolled out to new business groups as required.

This Solution allows attaching each external Oracle iRecruitment URL with one or more business groups. By doing so, the URL will secure the vacancies against one or more Business Groups. Therefore this design implements segregation of Oracle iRecruitment vacancies as per a set of Business Groups.

 

 

This image shows iRecruitment Visitors homepage before implementing the solution.

 

Note - After implementing the solution list of locations available for the search becomes restricted along with the restricted list of vacancies available for search.

 

Installation Steps

1. Create a custom copy of IrcVisitor.jsp and Compile

In this step, you will create a custom copy of IrcVisitor.jsp. You will have to repeat this step for each unique segregation URL that you wish to create in Oracle iRecruitment

cd $OA_HTML

cp IrcVisitor.jsp XXUSIrcVisitor.jsp

 

2. Edit the Custom Copy of IrcVisitor.jsp

cd $OA_HTML

vi XXUSIrcVisitor.jsp

 

Search for text

String responsibilitykey = "IRC_EXT_CANDIDATE";

And replace with above sentence by

String responsibilitykey = "XX_US_IRC_EXT_CANDIDATE";

 

Save the file XXUSIrcVisitor.jsp

 

Before to replace the responsibilitykey --

 

After replacing the responsibilitykey --

 

3. Compile the JSP file and bounce oacore

cd $FND_TOP/patch/115/bin/

perl ojspCompile.pl --compile -s 'XXUSIrcVisitor.jsp' --flush

cd $ADMIN_SCRIPTS_HOME

adoacorectl.sh stop

adoacorectl.sh start

 

4. Create Custom Responsibility

Create Custom Responsibility “XX US iRecruitment External Candidate Resp” as given below screen shot --

 

 

The features of this responsibility are similar to Standard IRC_EXT_CANDIDATE.

 

Note – Include all Function Exclusions at the time of responsibility creation and do not forget to set “Available From” option to “Oracle Self Service Web Applications”

 

5. Copy the profile options from IRC_EXT_CANDIDATE to XX_US_IRC_EXT_CANDIDATE

Use script Copy_Profile_Values.sql to copy the profile values

After running the script, able to see the profile option values assigned to the new responsibility, as shown in below –

 

 

 

 

Note – Profile Option values will be get copied across from the Standard Responsibility to the Custom Responsibility. However, the Script ensures that the profile option “IRC: Registration Responsibility” points to new custom responsibility

 

6. Create a Descriptive Flexfield for Mapping the Business Groups

In this step, create a context sensitive Flexfield against the Lookup entry screen. This will ensure that business groups can be picked from LOV when defining the lookup codes. So have to create Flexfield context for each segregated URL.

For Example – from setup perspective, will create lookup type = “US_VACANCY_BG_LIST” and each lookup code will be mapped to a business group via descriptive Flexfield.

The context sensitive Flexfield will ensure that this DFF will appear only when lookup codes against the lookup type = “US_VACANCY_BG_LIST”

 

Download US_VACANCY_BG_LIST.ldt file and following FNDLOAD command

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct US_VACANCY_BG_LIST.ldt

After running this FNDLOAD check following setups have been configured –

 

Go to Application Developer > Flexfield > Descriptive > Register

 

 

Query using following criteria

Application -- Application Object Library

Name -- FND_COMMON_LOOKUPS

 

 

Click on “Reference Fields”

 

 

Go to Application Developer > Flexfield > Descriptive > Segments

 

 

Query using following criteria –

Application – Application Object Library

Title – Common Lookups

 

 

 

Select US_VACANCY_BG_LIST > Segments

 

 

7. Assign business groups to lookup type for security

In this step, create lookup type names US_VACANCY_BG_LIST. This lookup type has lookup codes. Each lookup code entry will represent a business group that is available to the Custom Oracle iRecruitment Responsibility/ URL. This lookup type is attached to a custom Oracle iRecruitment responsibility via a custom profile option

Note – The name of the lookup type will match the DFF context value for Common Lookups descriptive Flexfield. The number of lookup types created will be same as the number of custom Oracle iRecruitment URL’s that you wish to create for segregating the vacancies. Typically if a URL restricts the vacancies listed by one business group, then for such cases only one single lookup will be created with the lookup type.

 

Create Custom Lookup –

Navigate to Responsibility Application Developer > Application > Lookups > Common

 

 

 

 

 

 

 

Save Everything.

 

8. Create a custom profile option

This profile option will map the lookup type to a responsibility. Effectively a set of business groups will be mapped to a responsibility. The custom iRecruitment responsibility will be mapped to a URL. Therefore this profile will dictate the list of business groups which have theirs vacancies exposed to a custom Oracle iRecruitment URL.

 

Download US_VAC_INCLUDED_ORG_LOOKUP_TYPE_PROFILE.ldt file and following FNDLOAD command

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct US_INCLUDED_ORG_LOOKUP_TYPE_PRF.ldt

 

After running the above script, the profile option and its value will be created as shown below

 

Navigate to responsibility Application Developer > Profile

Query Profile Name as “XX_US_VAC_INCLUDED_ORG_LOOKUP_TYPE”

 

 

Navigate to responsibility System Administrator > Profile > System

Query with following Criteria –

Responsibility -- XX US iRecruitment External Candidate Resp

Profile -- XX US Vacancy Included Organizations LKP Type

 

 

 

Note – Assign value US_VACANCY_BG_LIST to profile Option “XX US Vacancy Included Organizations LKP Type” at responsibility level, as shown in above picture. If FNDLOAD was run, then manual step is not required.

 

9. Assign Custom responsibility to US_GUEST_USER

Navigate to System Administrator > Security > User > Define

Assign responsibility “XX US iRecruitment External Candidate Resp” to GUEST_USER user as shown below

 

 

10. Create grant for Custom Responsibility

Navigate to Functional Administrator Responsibility > Home

Click Create Grant

 

 

In the Name field, type in a unique name “XX US iRecruitment External Candidate Resp”

In the Security Context Region give following Values –

Grantee Type – Specific User

Grantee – GUEST

Responsibility -- XX US iRecruitment External Candidate Resp

 

 

Click Next Button

In the Set region query up ‘IRC External Site Visitor Permission Set’ and Select Next

 

 

 

On the review page verify that data is correct and then click Finish button

The grant should be created

 

11. Create PL/ SQL packages for security

Run the SQL Scripts by connecting to APPS schema

XX_SECURE_VACANCY_PKG.pks

XX_SECURE_VACANCY_PKG.pkb

 

12. Register the row level security

Run the SQL scripts by connecting to APPs schema

XX_SECURE_VACANCY.sql

 

13. Run your Custom JSP page and test your work

 

 

Note - After implementing the solution list of locations available for the search becomes restricted along with the restricted list of vacancies available for search.

 

 

About

Welcome to My Oracle World Puneet Rajkumar

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today