My Oracle Support Banner

WMSCTLBD Form Consuming Too Much Temporary Space In TEMP Tablespace (Doc ID 2731026.1)

Last updated on AUGUST 20, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,

WMSCTLBD.fmb form consuming too much temporary space in TEMP tablespace

All users getting ORA-01652 error in TEMP tablespace.

ERROR
----------------------
ORA-01652 error in TEMP tablespace.

The trace shows highest elapsed time

INSERT INTO WMS_WAVEPLAN_TASKS_TEMP(expansion_code, plans_tasks,
 .........
    FROM mtl_material_transactions_temp mmtt ,
  wms_op_operation_instances wooi, wms_dispatched_tasks wdt ,
  mtl_system_items_vl msiv , mtl_item_locations_kfv milv ,
  wms_license_plate_numbers wlpn1 , wms_license_plate_numbers wlpn2 ,
  .... AND mmtt.organization_id =
  :org_id  AND mtrh.header_id = mtrl.header_id  AND mtrh.move_order_type = 6

  AND mmtt.move_order_line_id = mtrl.line_id  AND (  mtrl.reference in
  ('PO_LINE_LOCATION_ID', 'ORDER_LINE_ID', 'SHIPMENT_LINE_ID')   OR  
  (mtrl.reference IS NULL and mtrl.transaction_source_type_id = 5) )  AND
  mtrl.BACKORDER_DELIVERY_DETAIL_ID IS NULL

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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