My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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

Changes

 

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
Changes
Cause
Solution
References


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