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.
thanks for this post, just got it with Apex 5.1 same problem
thanks for helping out, just got it with Apex 5.1 same problem
ON “ORA-01841 WHEN CREATE USER”
Tried many different ways to apeace the date format for
l_account_expiry,
advised to use default TRUNC(SYSDATE)