Need a SQL query to list suppliers with access to the Supplier Portal in Oracle Fusion

Summary:

Need a SQL query to list suppliers with access to the Supplier Portal in Oracle Fusion

Content (please ensure you mask any confidential information):

Hi everyone,

I'm currently working in Oracle Fusion Cloud Procurement and I need to extract a list of suppliers who have access to the Supplier Portal. Specifically, I'm looking for a SQL query I can run in OTBI or via a BIP data model that returns the suppliers (and, ideally, their users) who have active access to the portal.

What I'm trying to identify:

• Supplier name / number
• Supplier user name and email
• Status (active/inactive)