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

Error to process Bank returns when JLBR_RETURN_ID information is missed

edited Jun 30, 2025 2:10PM in Payables, Payments & Cash Management 1 comment

Hi!

We have identified that some payments are not being updated with the "Return Code" after reading and processing the Bank's payment return file.

When analyzing one of the files, it was possible to identify that some payments are missing the JLBR_RETURN_ID information.

The LOAD job reads the entire file correctly, including leaving blank the records without the JLBR_RETURN_ID. However, due to the lack of this ID in some records, the entire reading is canceled and aborted, not updating the payments that have the correct ID.

In the log, it is possible to see that the records are deleted from the JL_BR_AP_INT_BANK_RETURNS table.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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