Additional External Predicate on SERVPROV VPD Not Working
Last updated on JULY 19, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms