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