Objective:
To Use a common Report in the Master Domian and filter its Records based on Vpd for each of the user avaialble under the Master Domain.
I wrote a VPD for a particular user to restrict a few records of a Report available at the Master Domain(admin)
VPD
Table :SHIPMENT
External Predicate:
SHIPMENT_GID IN (SELECT SHIPMENT_GID FROM SHIPMENT_REFNUM WHERE SHIPMENT_REFNUM_QUAL_GID ='RAJ01EPUDO.PUDO_PROVIDER_ID' AND SHIPMENT_REFNUM_VALUE LIKE '%KIALA%') OR SHIPMENT_GID IN (SELECT SHIPMENT_GID FROM SHIPMENT_INVOLVED_PARTY WHERE INVOLVED_PARTY_QUAL_GID ='RAJ01EPUDO.SHIPPER' AND INVOLVED_PARTY_CONTACT_GID LIKE '%KIALA%')
The vpd which I wrote for the USER got reflected both in the ADMIN and the USER
Inspite of associating the Vpd only to the User Role of the USER, the Report in the ADMIN was also affected .
Inorder to solve this issue we tried restarting the server.
Restarting the Server cancelled the effect of VPD on the Report.
Note:
The Vpd is still working perfectly for the Shipment Search Screens pulling the related shipments for USER based on the conditions specified in VPD.But failing to work for the Report.
Is there any reason for this inconsistent behaviorof OTM?
Can you also kindly help me in solving this issue?
To Use a common Report in the Master Domian and filter its Records based on Vpd for each of the user avaialble under the Master Domain.
I wrote a VPD for a particular user to restrict a few records of a Report available at the Master Domain(admin)
VPD
Table :SHIPMENT
External Predicate:
SHIPMENT_GID IN (SELECT SHIPMENT_GID FROM SHIPMENT_REFNUM WHERE SHIPMENT_REFNUM_QUAL_GID ='RAJ01EPUDO.PUDO_PROVIDER_ID' AND SHIPMENT_REFNUM_VALUE LIKE '%KIALA%') OR SHIPMENT_GID IN (SELECT SHIPMENT_GID FROM SHIPMENT_INVOLVED_PARTY WHERE INVOLVED_PARTY_QUAL_GID ='RAJ01EPUDO.SHIPPER' AND INVOLVED_PARTY_CONTACT_GID LIKE '%KIALA%')
The vpd which I wrote for the USER got reflected both in the ADMIN and the USER
Inspite of associating the Vpd only to the User Role of the USER, the Report in the ADMIN was also affected .
Inorder to solve this issue we tried restarting the server.
Restarting the Server cancelled the effect of VPD on the Report.
Note:
The Vpd is still working perfectly for the Shipment Search Screens pulling the related shipments for USER based on the conditions specified in VPD.But failing to work for the Report.
Is there any reason for this inconsistent behaviorof OTM?
Can you also kindly help me in solving this issue?
Comment