ERROR IN BANK RETURNS ORA-06510 ORA-06512

(Doc ID 1070921.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Financials for the Americas - Version 11.5.10.0 to 12.1.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
ARCABP
jlbrrrab.pls


Symptoms

Error when process the Brazilian bank return
ARCABP module: Batch Posting finished with an error:

Brazilian Localization calling hook
AR-arcipra: Error inserting record in AR_RECEIVABLE_APPLICATIONS
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APP
AR-arcipra: Error exit.


Trace showed system is trying to create this code combination.
Investigation showed there is a cross-validation rule that is preventing this from being created.

FND DEBUG LOG shows:
Exception in Procedure jl_br_interest_debit_memo :User-Defined Exception
Exception in Procedure calc_greaterthan_rec_tol :User-Defined Exception
Exception in Procedure interest_treatment :User-Defined Exception
Exception in Procedure Create_interest_adjustment :User-Defined Exception

Changes

Customer is testing the Bank Return process for the first time.   When they enter the data manually, there is no 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