My Oracle Support Banner

ECM 9.2: Automatic Netting Selection (TR_NET_ASEL) is Generating Unbalanced Netting Amount on MSSQL Database (Doc ID 2918266.1)

Last updated on JANUARY 13, 2023

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


After running Automatic Netting Selection (TR_NET_ASEL) the resulting Netting Worksheet is not balanced. The Netted Payable amount is not equal to Netted Receivable due to incorrect amount calculation in MSSQL database environments.

1. Create Netting Contract
      Cash Management > Administer Cash > Netting Contracts
2. Create Voucher for the supplier available in the Netting Participant
      Accounts Payable > Vouchers > Add/Update > Regular Entry    
3. Create 3 different group entries for customer available in netting participant
      Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
4. Run the Automatic Netting Selection process.
      Cash Management > Bi-Lateral Netting > Automatic Netting Selection
5. See the Netted amount is incorrect due to fraction amount. The netted receivables amount was fractionally more than Netted Payable.
      Cash Management > Bi-Lateral Netting > Review Single Netting


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.