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 FEBRUARY 28, 2017

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:

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms