Performance On Order Cancellation API For Sales Orders Imported OE_ORDER_PUB.PROCESS_ORDER via HVOP With Large Number Of Lines (Doc ID 1558565.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, Trx Changes & Cancellations

ACTUAL BEHAVIOR
---------------
OE_ORDER_PUB.PROCESS_ORDER is taking approximately 30 minutes to cancel a order of 1000 lines and more then 2.5 hrs to cancel order of 30,000 lines.Timelines from front-end are same. The performance is fine with small orders.

Users are looking for product to support order cancellation with 30000 - 100000 order lines (In single Order) using cancellation API.

EXPECTED BEHAVIOR
-----------------------
Expect to improved performance for large number of order lines.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Cancel order with 30000 - 100000 order lines (In single Order) using cancellation API.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cancel order by API.

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