FTI VPD Profile Not Working. Deleted Shipment is visible in FTI Adhoc Query
(Doc ID 2649459.1)
Last updated on MAY 23, 2023
Applies to:Oracle Transportation Intelligence Cloud Service - Version 20.1 and later
Information in this document applies to any platform.
Shipment is deleted from OTM and ETL is executed.
It is confirmed that the DEL_IN_OLTP column value is set to Y in D_SHIPMENT and also F_SHIPMENT_DETAIL table
It is observed that the deleted shipment is still visible in FTI - Adhoc Query although user accessing FTI is assigned a Role having VPD of FTI_DEFAULT
ETL fails with Error as below
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