Can Not Create Settlement Account For Counterparty In Treasury (Doc ID 1446245.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Treasury - Version: 12.0.6 to 12.1.3 - Release: 12 to 12.1
Information in this document applies to any platform.

Symptoms


Creating the settlement account for the counter party

Error raised when try to save.

ORA-6502 PL/SQL Numeric or value error
ORA_6512: at APPS.CE_BANK_AND_ACCOUNT_VALIDATION
at line 670

CE_VALIDATE_BANKINFO cevlbnks.pls
CE_VALIDATE_BANKINFO cevlbnkb.pls

CE_BANK_AND_ACCOUNT_VALIDATION cebavals.pls
CE_BANK_AND_ACCOUNT_VALIDATION cebavalb.pls

Line comes from PROCEDURE validate_IBAN

If IBAN is entered Error does not appear.
The error appears when IBAN is omitted from both Internal and External Counterparties.
IBAN is not required when entering an account in Cash Management.

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