Schedule Orders Program Running Long (Doc ID 2135329.1)

Last updated on MAY 07, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Production Instance

Find performance issue with the Schedule Orders program.

The following SQL in Schedule Orders seems to be running forever

SELECT
 H.header_id, L.Line_id, L.org_id
  FROM oe_order_headers_all H,
  apps.oe_order_lines_all L,
  wf_item_activity_statuses wias,
  wf_process_activities wpa
  WHERE H.header_id = L.header_id
  AND H.org_id = L.org_id
  AND NVL (H.transaction_phase_code, 'F') = 'F'
  AND H.open_flag = 'Y'
  AND L.open_flag = 'Y'
  AND L.line_category_code <> 'RETURN'
  AND L.item_type_code <> 'SERVICE'
  AND L.source_type_code <> 'EXTERNAL'
  AND L.org_id = :org_id
  AND wias.item_type = 'OEOL'
  AND wias.process_activity = wpa.instance_id
  AND wpa.activity_item_type = 'OEOL'
  AND wpa.activity_name = 'SCHEDULING_ELIGIBLE'
  AND wias.activity_status = 'NOTIFIED'
  AND wias.item_key = TO_CHAR (L.line_id)
ORDER BY L.top_model_line_id, l.line_id


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User responsibility
2. Submit the Schedule Orders program



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms