Performance Issue With Unapplied and Unresolved Receipts Register after Database Upgrade to 19c (Doc ID 2965844.1)

Last updated on MAY 20, 2024

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Unapplied and Unresolved Receipts Register is taking time to complete after upgrade from 12c to 19c.

Tkprof shows the following query as the cause of the issue:

The issue can be reproduced using the below steps.

	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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.