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 18.104.22.168 and later
Oracle Cash Management - Version 22.214.171.124 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