Payables Invoice Inquiry (ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY) - Data Security Policy issues

Summary

Payables Invoice Inquiry (ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY) - Data Security Policy granting access to all HZ_PARTIES record

Content

Hi all,

Payables Invoice Inquiry (ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY) has data security policies that are granting access to all HZ_PARTIES records for both Persons and Organizations.

When this duty role is granted to an user that has other roles, its data security policies are causing visibility issue because they allow users to view all parties records.

For instance, we have a custom role that mast have access to partner profile but with the following data security policy: "Access the trading community party for partner profile where they are in the partner account team of parent with full access". This of course is not working correctly when the user have both these two roles.