My Oracle Support Banner

Transactions Workbench: Credit Memos Are Taking Long To Save - Performance (Doc ID 1406684.1)

Last updated on JULY 10, 2020

Applies to:

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


Attempting to create a Credit Memo and when saving, it is taking a long time to complete:

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Transactions > Transactions > Query transaction using Number field
Go To:  Actions > Credit
In "Rules Method" choose LIFO, then in click "Credit Balance" and Save

This takes 10 minutes to complete the save and it is expected to take no more than 10 seconds


The SQL Statement running slow is the following:




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
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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