My Oracle Support Banner

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:

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


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.




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

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