Problem

When loading a WO file an error appears: Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small , even after following all process defined in the below wiki: https://communities.bentley.com/products/assetwise/exor/w/wiki/12830.on-loading-wo-invoice-file-an-error-ora-06502appears

the error still appeared.

Solution

1. The issue only occurs when using the Upload file option in the form (MAI3852). If the file is in the innerpath directory and the sequence number is specified, then it loads.
2. Another thing is, if we leave the sequence number blank then it tries to load a file that is not in the directory. Where does the form get the file name \ sequence number from? if one is not specified?
3. It seems that when Sequence No is not entered in MAI3852 the file name / sequence comes from the table INTERFACE_RUN_LOG in the database by incrementing its last (max) value in IRL_RUN_NUMBER column by 1. It is always best to leave the ‘Upload File’ value out and only enter the ‘Contract Id’ and ‘Sequence No’ values when loading the file.

Original Author:

Jyoti Patil