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