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 value too large for column

edited Jun 25, 2020 10:41AM in Payables, Payments & Cash Management 1 comment

Content

Hi

We are trying to load MT940E bank statement format into Oracle Fusion Cloud 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 taht

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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