Hello,

Obviously csv detail line does not match template. 

Can you export template definition to Excel and share both exported template and your file in Excel  or csv here? It would help in analysis...

Hello @Adam Bereda 

Find attached the template and the excel file with the values. 

Best Regards,

Hello, Jeremy,

I am not sure if system correctly recognizes header and detail lines of the template.

Can you check your template control definition (on Input Files tab there should be right-click action External File Template Control). 

It should be defined there that record type 1_HEAD has H value in first column, while record type 2_DETAIL has value D in the first column.

Something like that (seorry for screenshot from old IFS version):

Hi @Adam Bereda 

Yes i have already set it as you mentionned :

Best Regards, 

Jeremy

In the template you have record type 2_DETAIL, while in template control - 5_DETAIL. This might be the issue

Yes you’re right! 

But know i have another error but i will check with a technical consultant : 

Thank, 

Jérémy, 

Hi Jereme,

I have the same error “character string buffer too small”.  Did you find out the fix for this?

Thank you

I too got the error “ORA-06502: PL/SQL: numeric or value error: character string buffer too small” in 22R2 when attempting to load an external mixed payment file. Were you able to resolve this? Thanks!

No solution yet.

That oracle error means that you have a value in your load file that is longer than the field you are trying to load it to.  From looking at the two old files above, I’m guessing that you are trying to load the invoice reference into the invoice_id field, along with into the Invoice_reference field and that number is too long for the invoice_id field.

I’m also guessing that AMOUNT and AMOUNT_SIGN are two different things

Hi ! Concerning this functionality I was wondering if you know how AMOUNT_SIGN data should be entered ? what is the expected format in IFS ?

When I try to import my external file I get an error related to AMOUNT field, I think it might be linked to missing AMOUNT_SIGN data…

Thanks in advance!

Carole.