Post Bank Returns Program Fails With Error ORA-20001: APP-AR-11450 On Generate Interest Debit Memo

(Doc ID 2034691.1)

Last updated on FEBRUARY 03, 2016

Applies to:

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


When attempting to run Post Bank return process, the following error occurs.

Brazilian Localization calling hook
 SQL Code before calling JL:
AR-arcipra: Error inserting record in AR_RECEIVABLE_APPLICATIONS
ORA-20001: APP-AR-11450: Este Número de Transação já existe. Entre
AR-arcipra: Error exit.

The issue can be reproduced at will with the following steps:

Navigation:  Localizations> Transactions> Bank Collections> Returns> Post Bank Returns


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