We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
50
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!