AR_PAYMENTS_INTERFACE_ALL, column BATCH_NAME value too large for column
Content
Hi
We are trying to load MT940E bank statement format into Oracle Fusion Cloud 19 through OIC. In the process , we are getting errors in Load Interface at Receipts.
Record 12: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column BATCH_NAME.
ORA-12899: value too large for column ??? (actual: 30, maximum: 25)
Record 17: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column BATCH_NAME.
ORA-12899: value too large for column ??? (actual: 30, maximum: 25)
Table AR_PAYMENTS_INTERFACE_ALL:
One way to fix this is source data. but the source is coming from a third party bank which we cant ask them to fix, Is there any way to change the column length using any control file in fusion? If so please advise how to do that?