AR_ADUST_PUB.CREATE_LINELEVEL_ADJUSTMENT API Performance

(Doc ID 605070.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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

Symptoms

-- Problem Statement:
Trying to load adjustments using AR_ADJUST_PUB.Create_linelevel_Adjustment API and it is taking
35-40 secs to perform an adjustment. There are around 20,000 adjustments and it took almost 30
hours to perform those adjustments.

If an invoice has only one Invoice line and if we are performing an adjustment on that invoice
line using the new AR_ADJUST_PUB.Create_linelevel_Adjustment API, it takes less than a second to
perform the adjustment.

However, If an invoice has a large number of lines (for example 1300 lines) and performing an
adjustment on the invoice lines using the new AR_ADJUST_PUB.Create_linelevel_Adjustment API, it
takes about 35 to 40 secs.

-- Steps To Reproduce:
Run AR_ADJUST_PUB.Create_linelevel_Adjustment API for an invoice with a large number of lines.

Changes

 

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