My Oracle Support Banner

OTAC/TEE: User Type Fields in Administration Subject Area are NULL (Doc ID 2091774.1)

Last updated on DECEMBER 27, 2019

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 19A and later
Information in this document applies to any platform.


Problem Description:

User created a report to display user information using the System Use fields in the Administration Subject Area. 

The User Type and User Type Codes are all showing as null even though the users do have User Types assigned to their accounts in SmartOrg Administration.

  • The same report created in the Production Zone (or Testing Zone) shows the User Type information correctly.


Steps to Reproduce:

1.  Access Oracle Business Intelligence as a BI Author Developer

2.  Select to Create... > Analysis and choose the Administration Subject Area from the list of subject areas

3.  Add the following fields from the System Users folder to the Selected Columns section of the Criteria tab:

  • "System User - Personal Information"."User Full Name"
  • "System User - Permissions"."User - User Type"
  • "System User - Permissions"."User - User Type Code"

4.  Select the Results tab

The results will show a value for the User Full Name column but no values for any user in the User Type columns.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.