ORA-14462: cannot TRUNCATE temporary table in an autonomous transaction which is already in use by the parent transaction Cause: An attempt was made to TRUNCATE a temporary table in an autonomous transaction which is already in use by the parent transaction. Action: Make sure the temporary table is not being used by the parent transaction before trying to TRUNCATE in an autonomous transaction.