AW_CALC_HISTORY_STATISTICS job aborts and receive ORA-06502: PL/SQL: numeric or value error: number

Document ID : KB000088692
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
AW_CALC_HISTORY_STATISTICS job aborts and receive ORA-06502: PL/SQL: numeric or value error: number
Resolution:
Detailed Description and Symptoms

The AW_CALC_HISTORY_STATISTICS job is aborting or just running indefinitely forcing you to kill the job. In the jobs output file located in the remote agent's $AW_HOME/out directory you notice the following error:

ORA-06502: PL/SQL: numeric or value error: number precision too large


Solution

Please log into sqlplus as the Oracle Applications Manager user and run the following sql:

select SO_JOBID, SO_MODULE, SO_START_DATE, SO_JOB_STARTED, SO_JOB_FINISHED, SO_STATUS from  so_job_history where  SO_JOB_STARTED < sysdate -65;

You can adjust the sysdate portion appropriately, but what we are looking for are jobs that have a SO_JOB_STARTED date set to before the SO_START_DATE.
This is often an extreme difference and dates seem to most commonly show up as in 1970. If you have jobs with these mismatched dates please contact support.