My Oracle Support Banner

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 12, 2021

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.


Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.