AR/JL BR: How Can the Transactions Using Brazilian EFT-AR Solution Be Converted? Is There Any API to Update JL_BR_AR_COLLECTION_DOCS_ALL Table to set the DOCUMENT_STATUS = 'CONFIRMED'? (Doc ID 1945675.1)

Last updated on JUNE 05, 2024

Applies to:

Goal

You are working on the conversion specification for AR transactions in Brazil.

You use the EFT-AR Solution - Bank Remittance and Return file and could sometimes have transactions with 10 installments, where the Remittance batch and 'boletos' have already been sent to the bank before the conversion.  This means the localized tables would need to be updated, so then you would be able to process the bank return file for the converted transactions.

Is there any API to update JL_BR_AR_COLLECTION_DOCS_ALL table to set DOCUMENT_STATUS = 'CONFIRMED'?

The intention is to load the transactions and fill some attributes with the document_status from the transactions extracted.
After importing the transactions, you would format the batch, but will not send to the bank (it has already been sent before conversion) and then update JL_BR_AR_COLLECTION_DOCS_ALL.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.