My Oracle Support Banner

11i:XTR:Not Able To Reconcile Treasury Lines With Future Gl Date After Upgrade (Doc ID 415928.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Treasury - Version and later
Oracle Cash Management - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.
11.5.10, 2, 11i.AP.M ,11i.AR.N ,11i.CE.J ,11i.XTR.K
11.5 forms/US/CEXCABMR.fmb 115.436.115103.7


After upgrading from 11.5.7 to 11.5.10, Bank Reconciliation is not possible against Treasury lines that have a GL date in the next accounting period. The following error message is received. Reconciling future dated Treasury transactions was not a problem prior to the upgrade.

The clearing/reconciliation GL date cannot be earlier than the date of the receipt.

The issue can be reproduced at will with the following steps:
1. Cash management responsibility.
2. Create a bank statement with a receipt line in the current accounting period.
3. Reconcile the bank statement line against a Treasury settlement (Auction Rate Security-ARS) with the maturity date in the
next accounting period. (In this case semi-annual interest against the ARS is received prior to final maturity date)

The issue has the following business impact:
Not able to complete the bank statement reconciliation,and hence impacts the month close schedule.

Opening the next AR period is a potential workaround, but this is not acceptable to the business users.




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.