Automatic Remittances Creation Program (API) is Very Slow And Causing Performance Issues

(Doc ID 1529742.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
ARATREMB.pls
Concurrent Program: ARZCAR_REMIT - Automatic Remittances Creation Program
Concurrent Program: ARZCAR_REMIT_SRS - Automatic Remittances Creation Program (SRS)
AUTOREMAPI : Automatic Remittances Creation Program (API)
ARAREMMB : Automatic Remittances Master Program

Symptoms

Running of Automatic remittances creation program(API) is too slow.
Also Auto Remittance process is failing with ORA-12841 error

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