SEQ_TYPE And DEBIT_AUTHORIZATION_ID Are Null If Mandate Has End Date (Authorization Inactive Date) In The Future (Doc ID 1600161.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

When a mandate has an end date (Authorization Inactive Date) that is in the future, find that after running Automatic Receipts/Remittances, the IBY_TRXN_SUMMARIES_ALL columns SEQ_TYPE and DEBIT_AUTHORIZATION_ID are NOT populated on the settlement record.  We expect them to be populated.

If the mandate end date is later removed, and Automatic Receipts/Remittances run again, then the columns SEQ_TYPE and DEBIT_AUTHORIZATION_ID ARE populated.

Expected behaviour as per development:
1) During receipt creation, a record (authorization record) will be inserted into iby_trnxn_summaries_all table with SEQ_TYPE and DEBIT_AUTHORIZATION_ID as null values.
2) During remittance a new record (settlement record) will be inserted into iby_trnxn_summaries_all table with the values populated in SEQ_TYPE and DEBIT_AUTHORIZATION_ID columns.

Changes

Cause

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