How To Implement Document Sequencing For AR Direct Debit Transactions To An EFT File Format (Doc ID 2669137.1)

Last updated on DECEMBER 13, 2023

Applies to:

Goal

How to implement Document Sequencing for AR Direct Debit Transactions to an EFT file format.

User is using an eText template in a report that runs against the 'Funds Capture Authorization and Settlement Formats' seeded Data Model that returns the output in the required format.

When users create and submit the settlement batches, will trigger the entire process and this file is transmitted to the bank.

The requirement is that one field in the output should be a 4 digit file creation number. This field should increment after every batch run all the way from 0001 - 9999 and rollover back to 0001.

There is a similar requirement in AP wherein it could simply configure a 'periodic sequence' with a minimum and a maximum value.

Customer implemented a logic where they would extract the last 4 digits of the 'InstructionInternalID' hoping that this field would increment by 1.  The MBATCHID field in the iby_trxn_summaries_all table is the value that is used for the internal ID.  The values are the generated for the same in order of creation date time:
1. 10000
2. 11000
3. 10001
4. 10002
5. 12000
6. 10003
7. 10004
8. 10005

Customer would like to know how exactly the MBATCHID is generated, how can be use for their requirement.

Solution

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