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 OCTOBER 31, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms