Performance Issue For Few Items When Entered On Sales Order Line.
(Doc ID 1676183.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Agreements/Blankets/Contracts
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
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
Expect the entry to take only about a second like other items.
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 :
-- It takes few sec and then moves to qty field --
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