582: fii_util.stop_timer;
583: fii_util.print_timer('Duration');
584: end if;
585:
586: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_WH_TAX_T');
587: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
588:
589: COMMIT;
590:
727: fii_util.print_timer('Duration');
728: end if;
729:
730:
731: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PREPAY_T');
732: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
733:
734: COMMIT;
735:
806: fii_util.stop_timer;
807: fii_util.print_timer('Duration');
808: end if;
809:
810: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PAY_CHK_STG');
811: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
812:
813: COMMIT;
814:
1464: end if;
1465:
1466: COMMIT;
1467:
1468: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AP_INVOICE_B');
1469: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
1470:
1471:
1472: EXCEPTION
7135: -------------------------------------------------------------------
7136: -- Analyze Payment schedule table after all workers have completed
7137: -- updating the AP_PAYMENT_SCHEDULES_ALL table
7138: -------------------------------------------------------------------
7139: FND_STATS.GATHER_TABLE_STATS(g_ap_schema,'AP_PAYMENT_SCHEDULES_ALL');
7140: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
7141:
7142: FND_PROFILE.PUT('CONC_SINGLE_THREAD','Y');
7143: