EAR9.1+: Process is Selecting Cancelled Mandate When Creating Direct Debit SEPA File in Financial Gateway for a Customer With a Cancelled Mandate.

(Doc ID 1940055.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.1 version, Direct Debit

When creating Direct Debit SEPA files in Financial Gateway for a customer with a cancelled mandate the process is selecting the cancelled mandate.

When creating Direct Debit SEPA files in Financial Gateway the process should never select a cancelled mandate.

The issue can be reproduced at will with the following steps:

  1. Create an item and post it.
  2. Run the Direct Debits creation process AR_DIRDEBIT.
  3. Remit Direct Debit to bank.
  4. Run AR_Update.
  5. Cancel the mandate in Financial Gateway.
  6. Wait for one day (or update the field CANCEL_DT in record PS_PMT_MANDATE_HDR). The cancel date shouldn't be equal to sysdate.
  7. Create the EFT file and send to Financial Gateway.
  8. Run the Create EFT FIle process (AR_FG_PROC).
  9. Cancelled mandate is used and because of this the payment will be rejected by the bank.


The issue has the following business impact:
Due to this issue, Direct Debit payment files are rejected by the bank because cancelled mandate is used.


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