PSA_ACCTGGL ORA-600 Error

The Application Engine PSA_ACCTGGL program sometimes errors out with an ORA-600 error.

• Run the SQL below and restart the job.
• The job may fail more than once. Repeat the analyze steps below and continue restarting the Application engine program until it goes to success.

ANALYZE TABLE PS_PSA_ACCTG_TA0 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA2 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA3 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA4 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA5 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA6 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA7 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA8 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_CURR_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_CURR_TA2 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_IU_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_IU_TA2 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_PLANS_TA0 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_PLANS_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_PPD_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_RIDE_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_CF_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTDSTGL COMPUTE STATISTICS;

COMMIT;

blah blah

Move the AE temp tables to a tablespace that does not have blah blah.