My Oracle Support Banner

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.

Symptoms


ACTUAL BEHAVIOR

 Performance Issues Encountered with Post Mass Additions Program After 12.2.7 Upgrade

Following query is causing the performance issue


SELECT COUNT(1)
FROM
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 )

 

STEPS

The issue can be reproduced at will with the following steps:

FA > Addition > Mass Additions > Post Mass Addition



Changes

 

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