R12: AR/IBY: SEPA Direct Debit: Required Mandate ID Field Not Populated On AutoInvoice Generated Invoices

(Doc ID 1617339.1)

Last updated on APRIL 04, 2017

Applies to:

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


SEPA Direct Debits is a process to collect funds from customers using the ISO20022 format.

Sales invoices are generated from Sales Orders using AutoInvoice. The Receipt batches are created, then Remittance Batches, then the Create Settlement Batches request is run to generate the SEPA Direct Debit file.
The Mandate information (specifically MndtId, DtOfSgntr, AmdmntInd, CdtrSchmeId) is not populated on the SEPA Direct Debit file & will not be accepted by the banks.

Where the vast majority of all Sales Invoices are created via AutoInvoice, this is a major problem.

The issue does not occur for manually created invoices, only for those generated through AutoInvoice.

Expect the tags to be populated correctly for automatic invoices as well.

The issue can be reproduced at will with the following steps:
1. Create Sales Order
2. Generated invoice by running Automatic Invoices
3. Create and remit receipt
4. Run Create Settlement Batches to generate SEPA direct debit file.


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