Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WFR:WebVerifier:Filter Operating Unit Search values based on logged in user

sramineniJan 27 2016 — edited Feb 2 2016

Hi,

We have implemented Webcenter Imaging in our project.

Right now, when a user logs into WebVerifier and clicks on any of the pending batches, it takes us to the errored/pending Invoice.

In this pending Invoice, when user clicks on the Operating Unit Search, currently its bringing all the Operating Unit's irrespective of the user's settings.

We want to retrieve only those Operating Unit's that the logged in user is part of.

I am relatively new to WFR,WebVerifier and have the following questions.

1) How do I get to know all Orgs a logged in user is part of ? Is there a database table/query that I can use to identify all OU's a user is part of ?

2) When I checked the existing query to retrieve Operating Units, I found that it is retrieving all records from HR_OPERATING_UNITS. And this query is writted in the WFR sdp file. I would like to join the above query results to this and retrieve only valid OU's. Will that be possible ?

Or is there any other way that I can configure in configuration file or some other place through which I can retrieve only valid OU's.

Do let me know if I am not clear or need any more info.

Regards,

Srikanth R

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2016
Added on Jan 27 2016
8 comments
1,660 views