Oracle Blog

Puneet Rajkumar

Sunday Jul 15, 2012

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.

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”

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.

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.

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.