Recycle A Payment From A Suspense Account In Multi-db Setup (Doc ID 729972.1)

Last updated on MARCH 13, 2019

Applies to:

Goal

One may have a business requirement like below in a multi database setup.

Business Case(1)
Consider one wants to use the suspense account to collect payments when, for example, the destination account is unknown and when it is known to recycle it to the right account and then in a multi-database context, for example : if we collect the payment on database 1, and after that we find that the destination account is on database 2, we cannot recycle the payment to the right account.

Business Case(2)
Consider one needs to collect payments that must be allocated to multiple accounts. For example, a 1000$ check has been received from our distributor and this check is supposed to pay a 60$ bill on account 1, a 40$ bill on account 2, a 120$ bill on account 3 and so on. We may also want to use the suspense account to collect the payment as a repository of the global payment, and then recycle this global payment to the multiple destination accounts. However, if one or several accounts are located on database different from the database of the suspense account, this is no longer possible.

Solution

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