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:

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:

  arccmm() cust_trx_id: 0 cust_trx_line_id: 0 request_id: 22727796

Cause

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