ERROR IN BANK RETURNS ORA-06510 ORA-06512
Last updated on APRIL 17, 2018
Applies to:Oracle Financials for the Americas - Version 18.104.22.168 to 12.1.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
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
Customer is testing the Bank Return process for the first time. When they enter the data manually, there is no error.
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