My Oracle Support Banner

Issues In Outbound Non-Urgent Debit Customer Preferences Detailed (Doc ID 2976652.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Banking Payments - Version 14.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.7.0.3.0 version, Implementation Support

Issues in Outbound Non-Urgent Debit Customer Preferences Detailed


Issue:
Create New record in screen "PMDODCST", for some of the customesr not able to save the records In DB
Customer Name when ever goes high length values, it is not able to save the records In database


Expected:
It should save the Records in DB, since we allowed the Customer Name in STDCIFCR screen with length up to (105 char)

Analysis:
It is found that the Customer Name whenever goes beyond 35 char, it is not saving the records in DB
We found that the table "PMZM_OUT_NONURGDBTCUST_PREF" Cloumn COMPANY_NAME size of VARCHAR2(35 CHAR) Hence it fails to save the record.

Request to Alter the tables column size according to the STTM_CORE_CUSTOMER TABLE COLUMN CUSTOMER_NAME1(105 CHAR)as it is allowed with the Size of customer name up to 105 characters while creating customer.

ERROR
-----------------------
Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "PMZM_OUT_NONURGDBTCUST_PREF"."COMPANY_NAME" (actual: 36, maximum: 35)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Launch the screen PMDODCST
2)click new, select source ALL
3) select customer id , select customer account
4)Click Save
5)Click on Execute Query give the same inputs when we give for creation, result came as Transaction does not exists

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.