SEPA DD: No Detailed Transactions in SEPA Output File (PmtInfId is Empty) (Doc ID 1940099.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

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

Symptoms

Using template IBY_ISO_DD_CORE_V2_STD.xsl 120.0.12010000.7 to generate SEPA direct debit output.  However in the output file, there are no detailed transactions and no IBAN numbers relating to payer bank account or amounts.

Output file:

- <CstmrDrctDbtInitn>
- <GrpHdr>
 <MsgId>280</MsgId>
 <CreDtTm>2014-08-13T14:05:17</CreDtTm>
 <NbOfTxs>6</NbOfTxs>
 <CtrlSum>17280.00</CtrlSum>

....

- <PmtInf>
 <PmtInfId />
 <PmtMtd>DD</PmtMtd>
 <BtchBookg>false</BtchBookg>
 <NbOfTxs>0</NbOfTxs>
 <CtrlSum>0.00</CtrlSum>

Notice here that <NbOfTxs>0</NbOfTxs> (i.e. zero even though there are six transactions in iby_trxn_summaries_all).

The Create Settlement Batches log file contains the XML extract.  We see DocumentReceivable section and payer IBAN in the XML extract.
The 'Batch Booking' checkbox under 'Payment Logical Grouping' is already ticked.

STEPS
-----------------------
Generate a Funds Capture Settlement File
-Run Automatic Receipts
-Generate Remittance Batch
-Create Settlement Batch

Cause

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