Initialize Credit Summaries Table Performance Issue
Last updated on JULY 12, 2017
Applies to:Oracle Order Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version, Transaction Payment
You are facing performance issue with the report "Initialize Credit Summaries Table" and one of the insert statement is taking more than 70 minutes per execution.
This particular insert statement is fetching around 53 million gets per execution.
The most expensive query:
DELETE /*+ parallel(OE_CREDIT_SUMMARIES) */ FROM OE_CREDIT_SUMMARIES
BALANCE_TYPE <> 18
elapsed time = 9696.33 seconds
The second most expensive query:
INSERT INTO OE_INIT_CREDIT_SUMM_GTT (LINE_ORDERED_QUANTITY ,
LINE_UNIT_SELLING_PRICE, ORDER_INVOICE_TO_ORG_ID, RL_AMOUNT,
RL_QUANTITY_ORDERED, ORDER_ORG_ID , ORDER_TRANSACTIONAL_CURR_CODE,
elapsed time = 5305.38 seconds
STEPS TO REPRODUCE
1. Order Management Super User
2. Setup > Credit > Initialize Credit Summaries
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