My Oracle Support Banner

LAD Localization issue: CLL F034 - Collection Remittance Batch File (Doc ID 1557930.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.


Add new document types (used by other bank formats supported by CLL) to the existing JLBR_AR_DOCUMENT_TYPE lookups.

Oracle tax partner (Synchro) uses the field Document Type to identify if the Invoice is Service Trade Note or Market Trade Note.

The same field is used to identify the type of issue for BOLETO Process.

In the Remittance file needs to have the flexibility to change the type of issue.

Since Oracle LAD Localization indicated DOCUMENT_TYPE as the field which populates these position of the file, it is necessary to have in the document_type's list of values the following options:

01 = Bank prints (only simple Deposit Slip, Not Customized Deposit Slip)
03 = Customized printing by the bank (Simple Deposit Slips, Customized Deposit Slips and installment slip)
07 = Bank does not print
08 = Printing trough WEB (Slip via e-mail) without the bank printing
09 = Printing trough WEB (Slip via e-mail) with the bank printing

- When code 03, the customer must contact the bank, before sending the file, in order to define the slip is costum.
- When Code 07, the field 065/076, should have the OUR NUMBER given by the Client.
If the portfolio is Flex Collection:
04 = Flex Slip with Slip printed through Web (Slip via e-mail), accepts partial payment
06 = Flex Slip with Slip printed through Web (Slip via e-mail), does not accept partial payment.

(In case of Flex Collection, the field 065/076 – OUR NUMBER, on the remittance file, should be filled by the Client, or it will be filled by the Bank after the registration in the collection system, considering that the codes used will be 04 or 06 on the field type of issue.)

(In the case of the Flex Collection, Pledged Collection the option of Slip via e-mail should be a registration parameter.)




To view full details, sign in with your My Oracle Support account.

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

In this Document

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