Performance Issue on Saving Sales Order (Doc ID 2604092.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.2.5 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
Performance issue while saving sales order with taxes.
It takes 4-5 minutes to save the sales order.

EXPECTED BEHAVIOR
-----------------------
Expect better performance

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Sales Order form
2. Enter order information and Save

tkprof output shows the most expensive query:

SELECT DET_FACTOR_ID ,ORG_ID ,ORGANIZATION_ID ,LOCATION_ID ,
 SHIP_FROM_LOCATION_ID ,SHIP_FROM_STATE ,SHIP_FROM_COUNTRY ,
 SHIP_TO_LOCATION_ID ,SHIP_TO_STATE ,SHIP_TO_COUNTRY ,BILL_FROM_LOCATION_ID ,
 BILL_TO_LOCATION_ID ,APPLICATION_ID ,ENTITY_CODE ,EVENT_CLASS_CODE ,
..
FROM
JAI_TAX_DET_FACTORS WHERE (:B10 IS NULL OR (:B10 IS NOT NULL AND
 APPLICATION_ID = :B10 )) AND (:B9 IS NULL OR (:B9 IS NOT NULL AND
 ENTITY_CODE = :B9 )) AND (:B8 IS NULL OR (:B8 IS NOT NULL AND
..
 (:B9 IS NOT NULL AND ENTITY_CODE = :B9 )) AND (:B8 IS NULL OR (:B8 IS NOT
 NULL AND EVENT_CLASS_CODE = :B8 )) AND INTERFACE_DET_FACTOR_ID = :B3 AND
 NVL(TRX_TYPE ,'X') = NVL(:B2 ,NVL(TRX_TYPE ,'X')) AND :B1 = 'INTERFACE'

--

 

Changes

Cause

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