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.
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
WHERE PLAN_ID = :B2
AND ORDER_LINE_ID = A.SPLIT_FROM_LINE_ID
AND UTILIZATION_TYPE = 'ACCRUAL');
The issue can be reproduced at will with the following steps:
1. Run FAE
2. Performance issue
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