Order Import uses the Cost Based Optimizer of the database for optimizing queries. The Cost Based Optimizer uses generated statistical information to optimize queries. The Order Import Statistics concurrent program gathers statistics that will be used by the cost based optimizer. This concurrent program should be run after data is populated into the interface tables.

The Cost Based Optimizer performs a table analysis of all interface tables related to Order Import for determining optimum record processing. You can choose to submit this program (or not) prior to each submission of the Order Import concurrent program. If you normally process a similar number of interface records, you typically do not need to submit this program. There are no parameters for the submission of the Order Import Statistics concurrent program.

To schedule orders via concurrent program:

1. Navigate to the Run Requests SRS window, and select Order Import Statistics in the Request Name field.

2. Click Submit.

Below is a list of columns that are present in the interface tables, but not available via the Corrections Window:

• Header

  • ship_to_customer_id invoice_customer_id deliver_to_customer_id sold_to_phone_id supplier_signature supplier_signature_date customer_signature customer_signature_date orig_sold_address_ref order_firmed_date ib_location_code orig_sys_end_customer_ref orig_end_customer_address_ref end_customer_contact_ref end_customer_site_use_code

• Line

  • return_context price_request_code attribute_status ship_to_customer_id invoice_to_customer_id deliver_to_customer_id ship_to_customer_name invoice_to_customer_name invoice_to_customer_number deliver_to_customer_name line_category_code actual_shipment_date planning_priority order_firmed_date actual_fulfillment_date end_customer_site_use_code end_customer_contact_ref orig_end_customer_address_ref orig_sys_end_customer_ref

• Price Adjustments

  • price_adjustment_id

• Pricing Attributes

  • order_price_attrib_id override_flag

• Credits

  • sales_group_id sales_group_updated_flag

• Lotserials

  • quantity2 sublot_number

• Customer Information (Add Customer)

  • site_number location_number org_id is_sold_to_address new_address_id_sold_to