- 3,702,304 Users
- 2,239,629 Discussions
- 7,835,897 Comments
Forum Stats
Discussions
Categories
- 6 Industry Applications
- 3.1K Intelligent Advisor
- 3 Insurance
- 119 Oracle FLEXCUBE Core Banking
- 11 Oracle Insurance Policy Administration
- 400 On-Premises Infrastructure
- 132 Analytics Software
- 12 Application Development Software
- 1.7K Cloud Platform
- 700.4K Database Software
- 17.4K Enterprise Manager
- Hardware
- 47 Infrastructure Software
- 31 Integration
- 34 Security Software
BI Report for fetching users whose user account is locked
3063252
Posts: 7
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
Tagged:
0
This discussion has been closed.
Answers
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
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.