Table poz_sup_reg_pii does not return row in BPM Worklist
We are using the SupplierInternalRegistrationApproval task in the BPM Worklist, and we need to skip a participant according to the condition of a query. We are using the function "orcl:query-database('SELECT', true(), true(),'jdbc/ApplicationDBDS')=0)".
Our query needs to join poz_supplier_registrations and poz_sup_reg_pii.
Using the query with the poz_supplier_registrations table works perfectly. We even joined with the poz_address_requests table, which worked perfectly.
But when we join with the poz_sup_reg_pii table, it does not return any records.
This table is a secure table with VPD policies, but we need it to not have this policy to be used in the BPM Worklist.