My Oracle Support Banner

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

Last updated on AUGUST 12, 2022

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.