Skip to main content

Loading large CAMT files to IFS while "Allow Automatic Matching" toggle is turned on

  • November 26, 2025
  • 0 replies
  • 2 views

Forum|alt.badge.img+1

Loading large CAMT files (e.g., 6.6 MB containing 12,500 transaction lines and approximately 521,000 rows) into IFS Cloud 25R1 SU3 is currently not possible. When attempting this with the “Allow Automatic Matching” toggle enabled, the process fails with the error:

ORA-20124: Error.NULLVALUE: Field [LOAD_FILE_ID] is mandatory for Ext File Log and requires a value

Disabling the toggle avoids the error, but this forces manual matching—a highly time‑consuming process that is impractical for customers handling large volumes of transactions.

IFS R&D has provided a workaround:

  • The “Allow Automatic Matching” toggle must be turned off.

  • A new button has been introduced in External Payment Details: “Check and Match all items in background”.

    • This runs the matching process as a background job.

    • Previously, selecting “Check and Match all items” resulted in timeout errors; the background job avoids this.

While this solution is more feasible than manual one‑by‑one matching, it has limitations:

  • The background job takes up to 2 hours to complete for large files.

  • Customers also process smaller files, making it inconvenient to repeatedly toggle “Allow Automatic Matching” on and off depending on file size.

It is therefore a high‑priority requirement that large CAMT files should be manageable with the “Allow Automatic Matching” toggle enabled, without errors or excessive processing times.

  • Are other customers experiencing similar issues when processing large CAMT files in IFS Cloud?

  • What approaches or workarounds are currently being used to overcome this limitation?