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