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

Last updated on MAY 24, 2017

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.

Symptoms

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.?

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms