Error: Error ORA-6502 occurred in end of month non-financial maintenance while updating age ranges. - during End of Month Processing

The End Of Month processing error "Error ORA-6502 occurred in end of month non-financial maintenance while updating age ranges" is returned when Team Approach tries to convert an invalid date to 'DD-MON-YYYY' format.  Or "Error ORA-1839 occurred in end of month non-financial maintenance while updating age ranges."

Please submit a case with a request to run the "find_bad_age" SQL function against your database.  This will identify the account(s) that failed during the update in End Of Month processing.

*  Remember to mention to the client to not run the EOM job again after correcting the birthdates.  The goal is to make sure the errors are cleared for the next time EOM runs (probably a month from when the problem happened).

Steps to Duplicate


Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.