1 Reply Latest reply: Jun 24, 2013 3:00 PM by ThAn RSS

    Order Import program run very slow

    1017085

      Hi

      I use Order Import program to create sale order from tables interface.But it run very slow,about two hours for one record.

      How can i do it run fast?

      Thanks

        • 1. Re: Order Import program run very slow
          ThAn

          Hi,

           

          before checking metalink for patches (there are some performance related patches for order entry)

          you should check if statistics OE related tables

          - OE_HEADERS_IFACE_ALL,

          - OE_ORDER_HEADERS_ALL

          - OE_LINES_IFACE_ALL

          - OE_ORDER_LINES_ALL

          are up to date (check column last_analyzed in dba_tables). If not, run gather schema statistics
          program to collect current table statistics for OE schema.

          If this does not help, have a look at metalink and query for "order import" "performance"...

           

          Regards