My Oracle Support Banner

R12 AP: Bank Branch Name Cannot Have More Than 80 Characters (Doc ID 2438974.1)

Last updated on DECEMBER 04, 2020

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create bank for supplier, the following error occurs:
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20018: Failure at step 2ORA-20061: Failure at step 2
ORA-06512: at "APPS.POS_SBD_IBY_PKG", line 291
ORA-12899: value too large for column "IBY"."IBY_TEMP_EXT_BANK_ACCTS"."BRANCH_NAME" (actual: 81, maximum: 80)
ORA-06512: at "APPS.POS_SBD_PKG", line 576
ORA-20061: Failure at step 2
ORA-06512: at "APPS.POS_SBD_IBY_PKG", line 291
ORA-12899: value too large for column "IBY"."IBY_TEMP_EXT_BANK_ACCTS"."BRANCH_NAME" (actual: 81, maximum: 80)
ORA-06512: at line 1

STEPS:
The issue can be reproduced at will with the following steps:
1. Login as Payables Responsibility
2. Navigation: Suppliers > Entry
3. Query supplier and create Bank Details
4. Enter Branch Name more than 80 character

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.