FA: Performance Issues Encountered with Post Mass Additions Program after 12.2.7 Upgrade
(Doc ID 2566534.1)
Last updated on MARCH 05, 2021
Applies to:Oracle Assets - Version 12.2.7 and later
Information in this document applies to any platform.
Performance Issues Encountered with Post Mass Additions Program After 12.2.7 Upgrade
Following query is causing the performance issue
FA_DISTRIBUTION_HISTORY FDH WHERE FDH.BOOK_TYPE_CODE = :B1 AND
FDH.TRANSACTION_HEADER_ID_OUT IS NULL AND NOT EXISTS (SELECT 1 FROM
FA_DEPRN_DETAIL FDD WHERE FDD.DEPRN_SOURCE_CODE = 'B' AND
FDD.BOOK_TYPE_CODE = :B1 AND FDD.DISTRIBUTION_ID = FDH.DISTRIBUTION_ID )
The issue can be reproduced at will with the following steps:
FA > Addition > Mass Additions > Post Mass Addition
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