Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ability to Report on User Account Password Expiry Date

Submitted
252
Views
12
Comments
Brad Hughes
Brad Hughes Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Description

We are thinking of changing our password policy and would like to understand the impact of generating daily/weekly notifications, especially when the majority of colleagues attempt to log in at certain times within the payroll period to view their online payslips. We would like to avoid searching through the results of each report, generated by the process.

We would like the ability to report on the Password Expiry date of colleagues user accounts.

We have looked at the tables and views and cannot seem to find any table or fields that relate to Password Expiry date.

Kind Regards,

Brad

Use Case and Business Need

We require the ability to Report on the Password Expiry Date field within the Security Console, This will drastically aid our business in impact assessing changes to the password policy, - This will allow us to use a report to continuously assess the security within the Oracle HCM Cloud, manage expectations to the operation for support calls and self service queries, once the process is triggered.
 

More details

We currently do not have a way of reporting on Password Expiry Date,

Original Idea Number: b45b49c81b

Tagged:
5
Up
5 votes

Submitted · Last Updated

«1

Comments

  • Howie Lu
    Howie Lu Rank 1 - Community Starter

    Hi Brad

    This is the same query I just wanted to raise, I am investigating on this to get the password exipiry date but still no clue.

     

    Regards

    Haoye

  • Brad Hughes
    Brad Hughes Rank 3 - Community Apprentice

    Hi Haoye,

    I hope you are well,

    I'll continue to look into this and let you know if I find anything,

    cheers,

    Brad

     

  • Murali Gangidi
    Murali Gangidi Rank 1 - Community Starter

    Hi Haoye,

     

    I am also looking for the same. Did you find anything on this.

  • Murali Gangidi
    Murali Gangidi Rank 1 - Community Starter

    I am also looking for the same. Did you find anything on this.

  • Brad Hughes
    Brad Hughes Rank 3 - Community Apprentice

    Good Afternoon Haoye, 

    I hope you are well,

    Did you have any luck reporting on Password Expiry Date?, I hit a dead end and found no way of querying this,

    Kind Regards,

    Brad

  • Howie Lu
    Howie Lu Rank 1 - Community Starter

    Hi Brad

    Looks like this field is still not reportable. But in 19C there is a process called Locked Users we can use to ge the locked users.

  • Bojung Choi-Oracle
    Bojung Choi-Oracle Rank 1 - Community Starter

    I have the same needs as you wanted.

  • Brad Hughes
    Brad Hughes Rank 3 - Community Apprentice

    Unfortunately not, 

    This is still a problem for us, 

    We tried looking into the ASE_ tables and found a ASE_PWD_RESET_REQ table which has an expiry flag, but we haven't managed to validate whether this works the way we think.

    cheers,

    Brad

    ASE_PWD_RESET.PNG

  • Howie Lu
    Howie Lu Rank 1 - Community Starter

    This is a very good requirement Oracle need to implement ASAP

  • Sian S
    Sian S Rank 2 - Community Beginner

    We want to be able to report on this for monitoring and testing purposes.