Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

AR_PAYMENTS_INTERFACE_ALL, column BATCH_NAME value too large for column

edited Jun 25, 2020 12:55PM in Receivables & Collections 4 comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!