Performance Issue With AR_REVENUEADJUST_PUB API API (Doc ID 3000919.1)

Last updated on JANUARY 29, 2024

Applies to:

Symptoms

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
i.e
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.

Cause

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