Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Report to find which users of Expense module have a banking address — 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

Report to find which users of Expense module have a banking address

Received Response
70
Views
2
Comments
edited May 4, 2020 8:19PM in Reporting and Analytics for ERP 2 comments

Summary

Report to find which users of Expense module have a banking address

Content

Hello,

I need to write a BI Publisher report that lists all users that have access to the Expense module and if they have a banking address set up. Does anyone know which database tables I would use for this? I have found per_roles_dn, per_user_roles, and per_users for the security side and iby_ext_bank_accounts for the bank address side but am missing the tables to link these, if possible.

many thanks,

Lana

Version

11.1.1.9

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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