Shipping Transaction Form Performance Is Slow after Selecting from Menu (Doc ID 2193371.1)

Last updated on JULY 29, 2022

Applies to:

Symptoms

It is taking up to 45 seconds after selecting Shipping Transaction From (WSHFSTRX.FMB) from the menu for the form to open.



SELECT /*+ */ wdv.TRIP_ID,wdv.STOP_ID,wdv.row_id,wdv.type,
  wdv.delivery_detail_id,wdv.container_instance_id,wdv.container_name,
  wdv.DELIVERY_line_ID,wdv.split_from_delivery_detail_id,
  wdv.parent_container_instance_id,wdv.delivery_id,wdv.SOURCE_HEADER_ID,
  wdv.SOURCE_LINE_ID,wdv.SOLD_TO_CONTACT_ID,wdv.INVENTORY_ITEM_ID,
  wdv.PICKABLE_FLAG,wdv.ITEM_DESCRIPTION,wdv.CUSTOMER_ID,
  wdv.SHIP_TO_SITE_USE_ID,wdv.DELIVER_TO_SITE_USE_ID,wdv.SOURCE_CODE,
  wdv.SHIP_FROM_LOCATION_ID,wdv.SHIP_TO_LOCATION_ID,wdv.SHIP_TO_CONTACT_ID,
  wdv.DELIVER_TO_LOCATION_ID,wdv.DELIVER_TO_CONTACT_ID,
  wdv.INTMED_SHIP_TO_LOCATION_ID,wdv.INTMED_SHIP_TO_CONTACT_ID,wdv.PROJECT_ID,
  wdv.TASK_ID,wdv.LOCATOR_ID,wdv.MASTER_CONTAINER_ITEM_ID,
  wdv.DETAIL_CONTAINER_ITEM_ID,wdv.CARRIER_ID,wdv.SHIP_METHOD_CODE,
  wdv.UNIT_WEIGHT,wdv.UNIT_VOLUME,wdv.mode_of_transport,wdv.service_level,
  wdv.SHIPMENT_PRIORITY_CODE,wdv.CUSTOMER_ITEM_ID,wdv.SHIP_SET_ID,
  wdv.ARRIVAL_SET_ID,wdv.TOP_MODEL_LINE_ID,wdv.COUNTRY_OF_ORIGIN,
  wdv.CLASSIFICATION,wdv.SHIP_TOLERANCE_ABOVE,wdv.SHIP_TOLERANCE_BELOW,
  wdv.DEP_PLAN_REQUIRED_FLAG,wdv.TP_ATTRIBUTE_CATEGORY,wdv.TP_ATTRIBUTE1,
  wdv.TP_ATTRIBUTE2,wdv.TP_ATTRIBUTE3,wdv.TP_ATTRIBUTE4,wdv.TP_ATTRIBUTE5,
  wdv.TP_ATTRIBUTE6,wdv.TP_ATTRIBUTE7,wdv.TP_ATTRIBUTE8,wdv.TP_ATTRIBUTE9,
  wdv.TP_ATTRIBUTE10,wdv.TP_ATTRIBUTE11,wdv.TP_ATTRIBUTE12,wdv.TP_ATTRIBUTE13,
  wdv.TP_ATTRIBUTE14,wdv.TP_ATTRIBUTE15,wdv.ATTRIBUTE_CATEGORY,wdv.ATTRIBUTE1,
  wdv.ATTRIBUTE2,wdv.ATTRIBUTE3,wdv.ATTRIBUTE4,wdv.ATTRIBUTE5,wdv.ATTRIBUTE6,
  wdv.ATTRIBUTE7,wdv.ATTRIBUTE8,wdv.ATTRIBUTE9,wdv.ATTRIBUTE10,
  wdv.ATTRIBUTE11,wdv.ATTRIBUTE12,wdv.ATTRIBUTE13,wdv.ATTRIBUTE14,
  wdv.ATTRIBUTE15,wdv.CREATION_DATE,wdv.CREATED_BY,wdv.LAST_UPDATE_DATE,
  wdv.LAST_UPDATED_BY,wdv.LAST_UPDATE_LOGIN,wdv.PROGRAM_APPLICATION_ID,
  wdv.PROGRAM_ID,wdv.PROGRAM_UPDATE_DATE,wdv.REQUEST_ID,wdv.MVT_STAT_STATUS,
  wdv.TRANSACTION_TEMP_ID,wdv.HOLD_CODE,wdv.SOURCE_HEADER_TYPE_ID,
  wdv.ATO_LINE_ID,wdv.MOVE_ORDER_LINE_ID,wdv.ORGANIZATION_ID,
  wdv.HAZARD_CLASS_ID,wdv.QUALITY_CONTROL_QUANTITY,wdv.SERIAL_NUMBER,
  wdv.ORG_ID,wdv.RELEASED_STATUS,wdv.OE_INTERFACED_FLAG,
  wdv.REPLENISHMENT_STATUS,wdv.inv_interfaced_flag,wdv.MOVEMENT_ID,
  wdv.UNIT_PRICE,wdv.CURRENCY_CODE,wdv.ACTIVITY_CODE,wdv.FREIGHT_CLASS_CAT_ID,
  wdv.COMMODITY_CODE_CAT_ID,wdv.QUALITY_CONTROL_QUANTITY2,wdv.LPN_ID,
  wdv.ORIGINAL_SUBINVENTORY,wdv.container_flag,wdv.RELEASED_STATUS_NAME,
  wdv.SOURCE_HEADER_NUMBER,wdv.REQUESTED_QUANTITY,wdv.SHIPPED_QUANTITY,
  wdv.CYCLE_COUNT_QUANTITY,wdv.master_serial_number,wdv.REQUESTED_QUANTITY2,
  wdv.picked_QUANTITY,wdv.picked_QUANTITY2,wdv.SHIPPED_QUANTITY2,
  wdv.DELIVERED_QUANTITY,wdv.DELIVERED_QUANTITY2,wdv.CYCLE_COUNT_QUANTITY2,
  wdv.TO_SERIAL_NUMBER,wdv.CANCELLED_QUANTITY,wdv.CANCELLED_QUANTITY2,
  wdv.REQUESTED_QUANTITY_UOM,wdv.REQUESTED_QUANTITY_UOM2,
  wdv.FREIGHT_TERMS_CODE,wdv.FOB_CODE,wdv.SOURCE_name,
  wdv.SOURCE_HEADER_TYPE_NAME,wdv.SOURCE_line_number,wdv.CUST_PO_NUMBER,
  wdv.SRC_REQUESTED_QUANTITY,wdv.SRC_REQUESTED_QUANTITY2,
  wdv.SRC_REQUESTED_QUANTITY_UOM,wdv.SRC_REQUESTED_QUANTITY_UOM2,
  wdv.SHIPPING_INSTRUCTIONS,wdv.PACKING_INSTRUCTIONS,wdv.UNIT_NUMBER,
  wdv.TRACKING_NUMBER,wdv.seal_code,wdv.REVISION,wdv.SUBINVENTORY,
  wdv.LOT_NUMBER,wdv.PREFERRED_GRADE,wdv.CUSTOMER_REQUESTED_LOT_FLAG,
  wdv.DATE_REQUESTED,wdv.DATE_SCHEDULED,wdv.LOAD_SEQ_NUMBER,
  wdv.CUSTOMER_PROD_SEQ,wdv.CUSTOMER_DOCK_CODE,wdv.CUSTOMER_PRODUCTION_LINE,
  wdv.CUSTOMER_JOB,wdv.CUST_MODEL_SERIAL_NUMBER,wdv.gross_WEIGHT,
  wdv.tare_WEIGHT,wdv.NET_WEIGHT,wdv.WEIGHT_UOM_CODE,wdv.VOLUME,
  wdv.VOLUME_UOM_CODE,wdv.fill_percent,wdv.maximum_load_weight,
  wdv.maximum_volume,wdv.minimum_fill_percent,wdv.SHIP_MODEL_COMPLETE_FLAG,
  wdv.container_type_code,wdv.INSPECTION_FLAG,wdv.BATCH_ID,
  wdv.SHIPMENT_BATCH_ID,wdv.RECEIVED_QUANTITY,wdv.RECEIVED_QUANTITY2,
  wdv.SOURCE_LINE_SET_ID,wdv.LINE_DIRECTION,wdv.IGNORE_FOR_PLANNING,
  wdv.EARLIEST_PICKUP_DATE,wdv.LATEST_PICKUP_DATE,wdv.EARLIEST_DROPOFF_DATE,
  wdv.LATEST_DROPOFF_DATE,wdv.REQUEST_DATE_TYPE_CODE,
  wdv.TP_DELIVERY_DETAIL_ID,wdv.SOURCE_DOCUMENT_TYPE_ID,wdv.PARTY_ID,
  wdv.ROUTING_REQ_ID,wdv.SHIPPING_CONTROL,wdv.SOURCE_BLANKET_REFERENCE_ID,
  wdv.SOURCE_BLANKET_REFERENCE_NUM,wdv.PO_SHIPMENT_LINE_ID,
  wdv.PO_SHIPMENT_LINE_NUMBER,wdv.RETURNED_QUANTITY,wdv.RETURNED_QUANTITY2,
  wdv.SOURCE_LINE_TYPE_CODE,wdv.RCV_SHIPMENT_LINE_ID,wdv.SUPPLIER_ITEM_NUMBER,
  wdv.VENDOR_ID,wdv.SHIP_FROM_SITE_ID,wdv.filled_volume,wdv.wv_frozen_flag,
  wdv.PO_REVISION_NUMBER,wdv.RELEASE_REVISION_NUMBER,wdv.REFERENCE_NUMBER,
  wdv.REFERENCE_LINE_NUMBER,wdv.REFERENCE_LINE_QUANTITY_UOM,
  wdv.REFERENCE_LINE_QUANTITY,wdv.ORIGINAL_LOCATOR_ID,wdv.ORIGINAL_LOT_NUMBER,
  wdv.ORIGINAL_REVISION,wdv.CLIENT_ID,wdv.consignee_flag
FROM
 wsh_deliverables_v wdv order by SOURCE_HEADER_NUMBER, type, container_name,
  source_name, source_header_number, source_header_type_name,
  delivery_line_id



EXPECTED BEHAVIOR
-----------------------
Form should open in 2 to 3 seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility : Oracle Order Management
2. Navigate to Shipping
3. Click on Shipping Transactions
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.