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?