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
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.