VPD Not Affecting Users, Users in Domain A can See and Use Data In Domain B. (Doc ID 1329376.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.1 and later   [Release: 6.2 and later ]
Information in this document applies to any platform.

Symptoms

On OTM version 6.2.1 there are 2 sibling domains, each of these should not be able to see the data in the other, however they can.


EXPECTED BEHAVIOR
-----------------------
Expect each of the sibling domains to be able to see the data in its domain and from public, but not to see the data in its sibling domain.

For example, under the Public domain is Domain A and B, A should not be able to see data from B domain.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log onto Domain A.
2. Run a query for example for Rate Offering.
3. Note Data from both domain A and B is returned.
Note there are no Domain Grants in place.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can see data in both domains when they should not, also planning in domain A is using rates from domain B, this causes invalid shipments to be built.

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