My Oracle Support Banner

OTBI : Inactive Users Available In Prompts and Filters (Doc ID 2864172.1)

Last updated on NOVEMBER 27, 2023

Applies to:

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

Goal

On : 11.13.21.10.0 version, Analytics

Inactive User Available in OTBI

We have a user that was end dated in 2020 that is still showing up in OTBI . How do we remove the user from OTBI?

Customer has a prompt for Account owner such as

SELECT
   "Customer"."Account Owner Name" saw_0
 FROM "Sales - CRM Pipeline"

This shows inactive users in drop-down filter list

Also any Report filters like Employee, Opportunity owner etc. also lists active and inactive users
 

Solution

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
Goal
Solution


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