My Oracle Support Banner

SEPA DD: Pacs.003 Fails When The Creditor Address Line Is More Than 35 Characters Long (Doc ID 2896061.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Oracle FLEXCUBE Universal Banking - Version and later
Information in this document applies to any platform.


On : version, Production Support-SET

SEPA DD: Pacs.003 fails when the Creditor address line is more than 35 characters long

When the creditor address line in pacs.003 message is more than 35 characters long, the upload fails and logs an error code that the creditor ID is invalid.
 As per the debugs, System fails while creating the creditor ID as insert into pctm_creditor_id fails due to column length restriction. Address lines in the table have a column length of only 35 each whereas the pacs.003 file can have 2 address lines of 70 characters each as per SEPA rulebook.

creditor ID is invalid

The issue can be reproduced at will with the following steps:
1. Upload a pacs.003 file having creditor address line value of length > 35.

The issue has the following business impact:
Due to this issue, upload failed for the reported payment.


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

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