My Oracle Support Banner

SEPA Debit Auth Created With NULL Value For Column CREDITOR_LEGAL_ENTITY_ID (Doc ID 1530521.1)

Last updated on MARCH 16, 2020

Applies to:

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

Symptoms

When creating new debit authorizations (SEPA mandates), a NULL value is inserted in column IBY_DEBIT_AUTHORIZATIONS.CREDITOR_LEGAL_ENTITY_ID instead of a valid value.

Due to this issue, process Create Settlement Batches fails for these mandates with fatal error:
Error Message - ORA-20000: IBY_20220#ERRMSG=Payee Legal Entity is required

The issue started to occur after applying the following IBY Patches:


(1) p14033003_R12.IBY.B_R12_GENERIC1
(2) 14248732:R12.IBY.B.

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.