Which subject area to use for Employee Information

(Doc ID 2318874.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Analytics

Customer has created a BIP User Login Audit report with information on who logged in and when. The Dashboard prompts are for displaying the username and the email id of the user, which is required to be restricted to US/CAN employees only. Customer have a Business Requirement where they need to display data only for US/CAN in Dashboard Prompts.

They tried to restrict the data using two different approaches, but none works :

(1) Hard Code the US/CAN specific user roles in the Dashboard Prompt, but could not locate a subject area which stores this kind of information. Subject Area "Partners - CRM Partner Resource" -> Employee -> Employee Job Title, Employee Job Title Name is not meeting this requirement

(2) Tried filtering out the data based on the Employee Country, however, unfortunately the data is not showing up in the prompt LOV. (Subject Area -> Partners - CRM Partner Resource -> Employee Extension -> Country)

What would be a solution to address this requirement?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms