My Oracle Support Banner

Performance Issue With AR_REVENUEADJUST_PUB API API (Doc ID 3000919.1)

Last updated on JANUARY 29, 2024

Applies to:

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


Performance issue with API AR_REVENUEADJUST_PUB.

Step To Reproduce

1) Create an invoice with 500+ lines schedules over 7 years.
2) Created an onaccount CM without rules.
3) Create a custom package which will get the revenue scheduling data form the invoice and use that information to schedule the revenue on CM inline with Invoice
Lets take example of fist line

-> Unscheduled the revenue amount of line 1.
-> Call ar_revenueadjust_pub.earn_revenue procedure in loop to schedule the revenue for this line over 7 years inline with the amount and percentage on the invoice.

i.e Each line need to call the API 85 times and for 500 lines 85*500 = 42500 API calls needed.


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

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