Receipt Application API AR_RECEIPT_API_PUB ARP_BALANCE_CHECK Has Performance Issue (Doc ID 1534127.1)

Last updated on JUNE 08, 2016

Applies to:

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

Symptoms

Attempting to run the Receipt Application API, AR_RECEIPT_API_PUB (ARXPRECB.pls) ARP_BALANCE_CHECK (ARBALCHB.pls) and have performance issues.
It takes approximately 80 minutes to process 37,570 rows during ARP_BALANCE_CHECK in the sql:

SELECT SUM(NVL(AMOUNT_DR,0)) SUM_AMOUNT_DR, SUM(NVL(AMOUNT_CR,0))...

The expectation is that this sql should complete in just a few minutes or less for the same number of rows processed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms