Receipt Application API AR_RECEIPT_API_PUB ARP_BALANCE_CHECK Has Performance Issue
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms