My Oracle Support Banner

AR_ADUST_PUB.CREATE_LINELEVEL_ADJUSTMENT API Performance (Doc ID 605070.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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

Symptoms

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.

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
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.