Performance Issue when Importing Credit Memo Using AutoInvoice or Applying Credit Memo to an Invoice in Transaction Workbench
(Doc ID 2033242.1)
Last updated on JULY 22, 2024
Applies to:
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
Symptoms
When running AutoInvoice Import Program to import a credit memo (With the column REFERENCE_LINE_ID is populated in interface table), or when creating a credit memo to be applied to an invoice, the program/form hang and never end
Tkprof shows the following query as the cause of the issue:
The log file might show the following as the last line, which is where it is hanging: