AR_ADUST_PUB.CREATE_LINELEVEL_ADJUSTMENT API Performance
(Doc ID 605070.1)
Last updated on FEBRUARY 27, 2019
Oracle Receivables - Version 12.0.4 and later Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!