My Oracle Support Banner

R12/XTR Settlement Netting Provides Group Ref but Next settlement number is used for Reconciliation (Doc ID 2264000.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Treasury - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.


In the data below and/or the attached document, account information/ user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


Netted Settlement Number is Not Seen In Treasury Net Tab Settlement form instead Group ref provided in Net tab that makes no sense?

1. Treasury: In treasury netted settlements: SETTLEMENT NUMBER: 30345 AND 30346; AMOUNT: 14700+19600=34300
and Group ref: 16638 created in Net tab for these settlements, when Netting is done.

2. Cash Management: When one goes to Cash management and try to Find available Settlements (Treasury Transactions for Reconciliation) this netted settlement by using Group ref: 16638 is not available.
However Settlement Number: 30347 of amount: 34,300.00 is seen and can be Reconciled.

3. When one take sql results of the XTR_SETTLEMENT_SUMMARY Table there is a NET_ID, this has the Settlement Number stored in it and not Group Ref.?





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.