Performance Issue For Few Items When Entered On Sales Order Line. (Doc ID 1676183.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Agreements/Blankets/Contracts

ACTUAL BEHAVIOR
---------------
Entering some items on the sales order lines is taking 30 seconds.

The following query is showing as having poor performance:

select item, item_id, item_description, inventory_item_id,
 item_identifier_type, decode(item_identifier_type, 'INT', :1,'CUST', :2,
 item_identifier_type) item_identifier_type_meaning, inventory_item, Address,
  cust_address, item_definition_level, RANK
from
oe_items_ord_mv where ( UPPER(ITEM) LIKE :3 AND (ITEM LIKE :4)) AND (
 (sold_to_org_id = :5 or sold_to_org_id is null) and (item_status ='ACTIVE'
 or item_status IS NULL) and (cross_ref_status = 'ACTIVE' or
 cross_ref_status IS NULL) and ( org_independent_flag = 'Y' or
 cross_ref_org_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') ) )
 order by item


EXPECTED BEHAVIOR
-----------------------
Expect the entry to take only about a second like other items.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Orders, returns > Sales order
2. Enter order header details.
3. Go to line details. Enter items : 100/517/080JP or 100/210/070JP.
-- It takes few sec and then moves to qty field --

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot go live on 15-May

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