ARXRWMAI - Performance Issue While Reversing Receipts. Problem With JL.pld (Doc ID 1406591.1)

Last updated on FEBRUARY 15, 2016

Applies to:

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

Symptoms

On : 11.5.10.2 version, Receipts Related

Reversing a receipt is having performance issues

The following query shows as the top one in sorted tkprof, being executed millions of times:

Select applied_payment_schedule_id app_ps_id
from
ar_receivable_applications where cash_receipt_id = :1


call    count   cpu      elapsed    disk       query      current    rows
------- ------  -------- ---------- ---------- ---------- ---------- ----------
Parse   3836    0.01     0.09       0          0          0          0
Execute 1918    0.01     0.06       0          0          0          0
Fetch   6123294 13.97    609.93     22         35100522   0          122462046
------- ------  -------- ---------- ---------- ---------- ---------- ----------
total   6129048 13.99    610.09     22         35100522   0          122462046

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