My Oracle Support Banner

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

Last updated on AUGUST 10, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.