My Oracle Support Banner

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 DECEMBER 14, 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:

SELECT /*+ NO_MERGE(cm) PUSH_PRED(cm) */
cm.customer_trx_line_id,
cm.previous_customer_trx_line_id,
inv_type.allow_overapplication_flag,
cm.revenue_amount,
decode(cmt.credit_method_for_rules,
'LIFO', 'L',
'PRORATE', 'P',
'UNIT', 'U'),
decode(cmt.credit_method_for_rules,
'UNIT', nvl(cm.last_period_to_credit,
....
and cm.customer_trx_line_id = :cm_cust_trx_line_id
ORDER BY
cm.previous_customer_trx_line_id,
cmt.trx_date,
cm_rec.gl_date,
cm.customer_trx_line_id

 

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

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


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