Payment file rejected by bank due to limitation on file name characters
Hello All,
Payment file was rejected by bank when sent due to the limitation on the PAYMENTFILEID. As of now we are using PAYMENT FILE ID as sequence number (Pls see below bank file name format) to cater the requirement of unique file name. And there is a limitation of 7 characters on the bank side for the sequence number. Unfortunately PAYMENTFILEID is now 8 character in oracle system.
We are aware that we can use naming notation which contains following references:
&DATE
&TIME
&REQUESTID
&PAYMENTFILEID
Is there any alternate solution to have a custom sequence number to cater the 7 characters limitation? If not, can we reset the payment file id value every time it reaches above 7 characters? As of now, &REQUESTID and &PAYMENTFILEID are 8 characters in oracle system.