Skip to Main Content

APEX

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!

Account expiry shows 45 days

BaonergesMar 6 2025

Hi Everyone,

Why do all my accounts show that they will expire in 45 days? When I run the following code then check the END_USER_ACCOUNT_DAYS_LEFT, it says 45 days.

BEGIN
    FOR c1 IN (SELECT USER_NAME FROM APEX_WORKSPACE_APEX_USERS) LOOP
        APEX_UTIL.UNEXPIRE_END_USER_ACCOUNT(p_user_name => c1.user_name);
        htp.p('End User Account:'||c1.user_name||' is now valid.');   
    END LOOP;
END; 

Under security I have account lifetime set to 365, but when I unexpire accounts it doesnt take this into account.

How can I make accounts last for 365 days?

This post has been answered by jariola on Mar 14 2025
Jump to Answer
Comments
Post Details
Added on Mar 6 2025
3 comments
346 views