====== PSA_ACCTGGL ORA-600 Error ====== The Application Engine PSA_ACCTGGL program sometimes errors out with an ORA-600 error. ===== Manual Fix ===== * 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; ===== Reason for the Error ===== blah blah ===== Permanent Fix ===== Move the AE temp tables to a tablespace that does not have blah blah.