My Oracle Support Banner

FTI SERVPROV VPD Is Not Working For An Aggregate Table (Doc ID 2512878.1)

Last updated on FEBRUARY 03, 2020

Applies to:

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


When the query used the aggregate table : F_SHIPMENT_F_YEAR_MV and the Service Provider VPD Profile is not considered in FTI

The issue can be reproduced at will with the following steps:
1. Create VPD Profile and map it to FTI Users.
2. Ensure the query used in FTI has table : F_SHIPMENT_F_YEAR_MV
3. Check the dashboards with the queries.


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.