Additional External Predicate on SERVPROV VPD Not Working
(Doc ID 2288118.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Transportation Management Cloud Service - Version 6.4.1 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.
When using an External Predicate for the INVOICE table all invoices can be seen, including invoices that belong to other Service Providers.
The issue can be reproduced at will with the following steps:
1. In the SERVPROV VPD Profile add the additional external predicate:
(invoice.servprov_gid IN (SELECT user_association.user_association_value FROM user_association WHERE user_association.gl_user_gid = sys_context('gl_user_ctx', 'log_in_user_gid') AND user_association.user_association_qual = 'SERVPROV' )) Insert/Update/Delete
2. Login as Service Provider using the role
Invoices are not restricted as expected. All invoices are visible.
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