ORA-01841 when create/edit User

Ever got a “ORA-01841: (full) year must be between -4713 and +9999, and not be 0” Error when trying to edit an existing user in APEX Administration Panel (Manage Workspaces > Manage Developers and Users) ?

The reason to this error can be a too large value in Manage Instance > Security > Account Password Lifetime (days). For example you can store there a number of 999999 days which is saved without any problems, but when trying to edit an user you get the ORA-01841 error message.

This error occurs in APEX 4.0.2.*, reported as Bug in APEX Forum.

Thanks Pascal for showing this error to me.

2 thoughts on “ORA-01841 when create/edit User

  1. thanks for this post, just got it with Apex 5.1 same problem

  2. thanks for helping out, just got it with Apex 5.1 same problem

    Tried many different ways to apeace the date format for
    advised to use default TRUNC(SYSDATE)

Leave a Reply

Your email address will not be published. Required fields are marked *