List Of Responsible Parties In Add Event Form Cannot Restricted Via VPD (Doc ID 1086021.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

Business Requirement:

Require the ability to restrict the list of Responsible Parties in the Add Event form. This has been attempted unsuccessfully via the VPD profile (predicate for table APP_ACTION_RESP_PARTY_P).

There are several responsible parties who add shipment events, each of them having a user role. Each role must only be able to see the corresponding responsible party, because each responsible party has a particular status group profile assigned to restrict the events possible to add to a particular role.

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