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

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version: 11.5.10
Oracle Cash Management - Version: 11.5.10 to 11.5.10
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

Symptoms

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.

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

STEPS
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)

BUSINESS IMPACT
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.


Changes

none

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