Performance Issue on Public API for Receivables Adjustments (AR_ADJUST_PUB.CREATE_ADJUSTMENT and AR_ADJUST_PUB.CREATE_LINELEVEL_ADJUSTMENT) (Doc ID 3045744.1)

Last updated on SEPTEMBER 05, 2024

Applies to:

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

Public APIs AR_ADJUST_PUB.CREATE_ADJUSTMENT and AR_ADJUST_PUB.CREATE_LINELEVEL_ADJUSTMENT are having performance issues

Steps to Reproduce:

Responsibility: Receivables responsibility
Navigation: Control > Requests > Run

Run custom concurrent program that calls the API (Note: The issue can also be reproduced while running the API from SQLPlus, without a custom wrapper)

Tkprof shows the following SQL statement as the top query:

	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

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