I need assistance with writing a SQL query to retrieve a list of users and their attached roles in Oracle Fusion. Specifically, I am looking for a query that can:

1. Identify all users within the Oracle Fusion system.
2. List the roles assigned to each user.
3. Include relevant details such as user IDs, usernames, role names, and any other pertinent information.

Could someone provide a sample query or guide me through the process of constructing this query?