My Oracle Support Banner

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

Last updated on AUGUST 23, 2023

Applies to:

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

Symptoms

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.

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.