My Oracle Support Banner

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.

Symptoms

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

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

Changes

 

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
Changes
Cause
Solution


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