Performance Issue on Saving Sales Order
(Doc ID 2604092.1)
Last updated on DECEMBER 30, 2020
Applies to:Oracle Financials for India - Version 12.2 and later
Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.
On : 12.2.5 version, Transaction Entry
Performance issue while saving sales order with taxes.
It takes 4-5 minutes to save the sales order.
Expect better performance
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 ,
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'
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