BI Report for fetching users whose user account is locked — oracle-tech

    Forum Stats

  • 3,702,304 Users
  • 2,239,629 Discussions
  • 7,835,897 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

BI Report for fetching users whose user account is locked

30632523063252 Posts: 7
edited December 2017 in HCM Cloud Service

Hi,

    I am currently using Oracle Business Intelligence 11.1.1.9.0 product. Can anyone guide me that in Oracle Fusion Cloud "How can I get the User accounts that is locked?" in Oracle BIP Reports ? I have already checked "PER_USERS" table and other tables in HCM Data Source  but unable to find table that provide relevant data for User whose account is locked but Active and not suspended.

Regards,

Sahil Kumar

Answers

  • timdextertimdexter Posts: 130
    edited November 2017

    Sahil

    Your question would be better answered in the HCM forum rather than here in the BIP forum. Once you have the table(s) you need to hit. If you have issues with the report, then come back here.

    Cheers

    Tim

  • user8579949user8579949 Posts: 1
    edited December 2017

    I have the same question.  Did a quick search and did not see any answers posted.

    I tried running the 'User Details System Extract Report', however it appears all users (including those that are locked) still have an ACTIVE_FLAG = Y.

This discussion has been closed.