} Oracle iRecruitment Vacancy Segregation Solution

http://apps2fusion.com Anil Passi

}Oracle iRecruitment Vacancy
Segregation Solution
http:/ / apps2fusion.com
Anil Passi
Detailed design & steps for implementing iRecruitment Vacancy Split

Anil Passi } Apps2fusion } 10/10/2008

Version 1.0 - Created

Version 1.1 - Changed DFF fromattribute1 to attribute15 to increase the likelihood of unused segment




























} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 2

Oracle iRecruitment Vacancy
Segregation Solution
http:/ / apps2fusion.com
Anil Passi
Detailed design & steps for implementing iRecruitment Vacancy Split
This document describes the detailed steps for implementing Vacancy segregation in Oracle iRecruitment. The
solution is configurable and can be very easily be 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.

Note- Installation instructions are in violet colour
The image below shows the Oracle iRecruitment External homepage before implementing the solution
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 3



The image below shows the Oracle iRecruitment Visitor homepage after implementing the solution using the
custom URL. Notice that after this solution has been implemented, the list of locations available for the search
becomes restricted along with the restricted list of Vacancies available for search.
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 4


} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 5

Background
Client has a need to create multiple external facing URL's in Oracle iRecruitment. Each such URL should present
vacancies from either a specific business group or from a group of business group. This solution allows to create
multiple URL's in Oracle iRecruitment.
The design of this solution comprises of the following steps
A custom copy of IrcVisitor.jsp will be created
The customized copy of IrcVisitor.jsp will reference a custom Oracle iRecruitment responsibility
A lookup type will be defined for each custom Oracle iRecruitment responsibility.
Each lookup code entry within lookup type will map to a Business Group.
The lookup type definition will be attached to custom Oracle iRecruitment responsibility via a profile
option. Effectively this allows a set of business groups to be associated with a specific custom
iRecruitment responsibility.


Assumptions
In this document, following assumptions will be made
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 6

1. Name of the business group for which vacancies but be segregated is BG01. In your implementation you
can name this as per your organization naming convention. The steps against BG01 can be repeated
across other business groups.
2. Attribute15 of FND_LOOKUP_VALUES is available for use in a Descriptive Flexfield. This attribute will
contain the Business Group Id entries for mapping business groups to responsibilities.
3. Implementation of custom look and feel skin for different URLs is not within the scope of this document.
Custom skin will be implemented as a separate solution.

Installation Steps

Create 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 segregated URL that you wish to create in Oracle iRecruitment
Copy IrcVisitor.jsp

cd $OA_HTML
cp IrcVisitor.jsp xxbg01IrcVisitor.jsp

Edit the Custom Copy of IrcVisitor.jsp
cd $OA_HTML
vi xxbg01IrcVisitor.jsp
Search for text
String responsibilityKey="IRC_EXT_CANDIDATE";
and replace the above sentence by
String responsibilityKey ="XXBG01_IRC_EXT_CANDIDATE";
Save the file xxbg01IrcVisitor.jsp


R12 Only - Compile the J SP file and bounce oacore
cd $FND_TOP/patch/115/bin/
perl ojspCompile.pl --compile -s 'xxbg01IrcVisitor.jsp' --flush
cd $ADMIN_SCRIPTS_HOME
adoacorectl.sh stop
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 7

adoacorectl.sh start

Create Custom Responsibility
Assuming the apps password is apps, run the FNDLOAD command as shown below to create a
responsibility with short name XXBG01_IRC_EXT_CANDIDATE

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXBG01_IRC_EXT_CANDIDATE.ldt

XXBG01_IRC_EXT_CANDIDATE.ldt


This step will create a responsibility as shown below.


} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 8

The features of this responsibility are similar to standard responsibility IRC_EXT_CANDIDATE. The
FNDLOAD will ensure that the Function Exclusions are included at the time of responsibility creation.
You will notice that the "Available From" option is set to Oracle Self Service Web Applications

Copy the profile options from IRC_EXT_CANDIDATE to
XXBG01_IRC_EXT_CANDIDATE
Run the SQL script XX_SECURE_VACANCY_PKG_30.sql below by connecting to APPS Schema.
This script will copy the profile option values from the standard responsibility to the custom
responsibility.

XX_SECURE_VACANCY_PKG_30.sql

XX_SECURE_VACANCY_PKG_30.sql

After running the script, you will be able to see the profile option values assigned to the new
responsibility, as shown in three images below


} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 9




} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 10


You will notice that the profile option values have been copied across from the standard Responsibility to
the custom Responsibility. However, the script ensures that the profile option "IRC: Registration
Responsibility" points to the new custom responsibility.

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

For example, from setup perspective, , you will create a lookup type=XX_BG01_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 defining lookup codes
against the lookup type=XX_BG01_VACANCY_BG_LIST

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


After running this FNDLOAD, you will notice the following setup has been configured. This can be
checked using Application Developer responsibility
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 11




} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 12




Assign business groups to lookup type for security
In this step you will create a lookup type named XX_BG01_VACANCY_BG_LIST. This lookup type will
consist of lookup codes. Each lookup code entry represents 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.

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 the 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 code will be created within the lookup
type.

Create a lookup type as show below, by navigating to Application Developer, and then clicking
/Lookups/Common
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 13



} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 14



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 option value will dictate the list of business groups which have theirs vacancies exposed to a
custom Oracle iRecruitment URL.

Run the FNDLOAD as shown below
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_VAC_INCLUDED_ORG_LOOKUP_TYPE.ldt
XX_VAC_INCLUDED_ORG_LOOKUP_TYPE.ldt


After running the above script, the profile option and its value will be created as shown below
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 15



} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 16






Assign profile option value to secure responsibility
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 17

Assign value of XX_BG01_VACANCY_BG_LIST to profile option " XX Vacancy Included Organizations
Lookup Type" at responsibility level, as shown in previous step. If FNDLOAD was run, then manual step
is not required


Assign custom responsibility to GUEST user
Navigate to System Administrator, and in User definition screen query for GUEST username. Assign
responsibility "XX BG01 iRecruitment External Candidate" to the GUEST user as shown below


Create grant for custom responsibility
Follow the instructions below to create grants for the custom responsibility
Go to the Functional Administrator responsibility and do the following:
a. The Grants region should open as the default
b. Click on the Create Grant button
c. In the Name field, type in a unique name "XX BG01 Grant iRecruitment External Candidate"
d. In the Security Context Region for the Grantee Type, select from the LOV Specific User
e. In the Grantee field query up GUEST
} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 18

f. In the Responsibility Field query up the "XX BG01 iRecruitment External Candidate" responsibility
g. Click the next button
h. In the Set region query up IRC External Site Visitor Permission Set and select Next
i. On the review page verify that the data is correct and then click the Finish button.
j. The grant should be created

For convenience, the screenshots are attached as below


} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 19



} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

Anil Passi } Page 20





Create pl/ sql packages for security
Run the SQL scripts by connecting to APPS Schema
XX_SECURE_VACANCY_PKG_10.sql
XX_SECURE_VACANCY_PKG_20.sql
XX_SECURE_VACANCY_PKG_20.sql XX_SECURE_VACANCY_PKG_10.sql

} Oracle iRecruitment Vacancy Segregation Solution
http://apps2fusion.com Anil Passi

} Page 21

Register the row level security
Run the SQL scripts by connecting to APPS Schema
XX_SECURE_VACANCY_PKG_25.sql
XX_SECURE_VACANCY_PKG_25.sql