Additional External Predicate on SERVPROV VPD Not Working (Doc ID 2288118.1)

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.

Symptoms

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
(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.

Cause

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