Table poz_sup_reg_pii does not return row in BPM Worklist — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!