On the Talent Profile page, you can use custom regions to display business specific details. You can configure custom regions if you need to use information structures other than EITs or SITs. Use a SQL Statement to retrieve the business specific information from the database and then configure the custom regions to display the content. You can configure a maximum of 10 custom regions on the Talent Profile page.

To display custom content as regions, complete the steps explained in this topic.

Prerequisites

1. Set up the following profile options to enable the Oracle Application Framework Personalization feature:

   • Personalize Self-service Defn

   • FND: Personalization Region Link Enabled

   • Self Service Accessibility Features

   For information on the profile options, refer to the Oracle Application Framework Personalization Guide

2. Create a database view based on one or more tables in the database. Consider security and information requirements before creating a database view.

   You can use the Additional WHERE clause to display the data of the worker whose profile is being viewed, if the database view returns data for all workers. This clause uses specific parameters that are passed dynamically. Following are the parameters:

   • ##PERSON_ID## - Person ID of the currently viewed worker's profile

   • ##PRIMARY_ASSIGNMENT_ID## - Assignment ID of the currently viewed worker's profile

   • ##LOGIN_PERSON_ID## - Person ID of the logged in worker who is a manager

   • ##BUSINESS_GROUP_ID## - Business group ID of the currently viewed worker

   • ##EFFECTIVE_DATE## - Effective date in the format "YYYY-MM-DD HH24:MI:SS"

   Following rules apply when you create a database view:

   1. Views can be based on any database table.

   2. Create an alias starting with 'D_' or 'd_' for the view columns that you want to display on the Talent Profile page.

   3. Use the HR_TP_NAME_TRANSLATIONS lookup type to create a lookup for each column that is created as an alias in the previous step. The lookup code must be the same as the column alias. Provide a user friendly value in the Meaning column as this value appears as the column header in the custom region of the Talent Profile page.

      Example of Lookup Codes

      Code	Meaning
      D_FULL_NAME	Full Name
      D_PARTY_ID	Party Identifier

3. Write a SQL statement to retrieve data from the database view.

Displaying Custom Content as Talent Profile Regions

Example 1

In this example, you display the Worker Information region that has two columns: Name and Party Number. The Additional Where clause in this example has a person_id IN clause where the login_person_id and the person_id of the worker whose profile is being viewed are passed.

1. Navigate to the Talent Profile page.

2. Click the global Personalize Page link. As you have set the Self Service Accessibility Features profile option, the Page Layout Personalization page appears.

3. Select the required Personalization level and click Go.

4. Click the Content tab and select a layout where you want to add the custom region

5. Click the Add Content icon to add the new region.

   The Add Content page appears.

6. Select any one of the available Dynamic View regions. 10 Dynamic View predefined regions are available. Oracle recommends that you select only one dynamic region for each flexible layout.

7. Click Apply. You can view this region on the Talent Profile page.

   As a next step, configure the dynamic region to enter the title.

8. Click the Personalize icon for that region.

9. Scroll to the DyncVwFlexRN<#>.TextCellRN row and click the Personalize icon of the Static Styled Text item.

10. Change the Prompt field with the desired title such as Worker Information and click Apply.

    The Dynamic View has three parameters that you must configure to display data in the region:

    • Layout Style: Valid values are: TABLE - Table Layout and FORM - Message Component (Form) Style Layout

    • DyViewName: The database view name that you created to show the required data in the custom region.

    • DyWhereClause: Any additional where clause that is required to further filter the data retrieved from the view.

11. Click the personalize icon of the DyViewName item to specify the database view name.

12. Change the Prompt field with the desired database view name for the region and click Apply.

13. Click the personalize icon for the DyWhereClause item to specify the additional where clause.

14. Change the Prompt field with the desired additional Where Clause for the region and click Apply.