My Oracle Support Banner

Fund Accrual Engine Doing Full Table Scan On OE_ORDER_LINES_ALL (Doc ID 2895237.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

Oracle Trade Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
Fund Accrual Engine doing full table scan on OE_ORDER_LINES_ALL

After upgrading from 12.1.3 to 12.2 the Fund Accrual Engine Concurrent Program is having a performance issue on the following query:


SELECT COUNT (1)
  FROM OE_ORDER_LINES_ALL A
 WHERE A.SPLIT_FROM_LINE_ID = :B1
  AND EXISTS
  (SELECT 1
  FROM OZF_FUNDS_UTILIZED_ALL_B
  WHERE PLAN_ID = :B2
  AND ORDER_LINE_ID = A.SPLIT_FROM_LINE_ID
  AND UTILIZATION_TYPE = 'ACCRUAL');

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run FAE
2. Performance issue




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
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.