My Oracle Support Banner

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

Last updated on DECEMBER 10, 2019

Applies to:

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

Symptoms

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.

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

STEPS
-----------------------
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.

Cause

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
Symptoms
Cause
Solution
 Have more questions?
References


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