My Oracle Support Banner

Objects With DEL_IN_OLTP Set To Y Are Visibile To Users With FTI_DEFAULT VPD Profile Associated (Doc ID 2637034.1)

Last updated on FEBRUARY 17, 2020

Applies to:

Oracle Transportation Intelligence Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

OTM objects (For Example: Shipment) are marked DEL_IN_OLTP='Y'. User Is associated with a User Role that has FTI_DEFAULT VPD Profile associated. When the User runs an analysis in FTI such objects are still visible in the results. 

Expected behavior is that since FTI_DEFAULT VPD Profile has the required external predicates needed to filter the deleted objects (DEL_IN_OLTP='Y') from being displayed, these objects should not be visible to the Users. 

Cause

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
Symptoms
Cause
Solution


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