R12.1:CE: Unable To Find Available Transactions For Reconciliation Based On Journal Entry Name

(Doc ID 2253540.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

Unable to find available transactions for reconciliation based on Journal Entry Name

Expect to find available transactions for reconciliation based on Journal Entry Name

The issue can be reproduced at will with the following steps:

1. Responsibility: Cash Management
2. Path: Bank Statements - Reconciliation / Unreconciliation (CEXCABMR)
3. Query a bank statement
4. Go to Bank Statements Lines

Go to Find Transactions and select the Journal option and enter the Journal Entry Name as Rev%Align%

Nothing is found.

Unable to find available transactions for reconciliation based on Journal Entry Name.

WORKAROUND: The user is able to query the transaction ONLY using period name. Eg: FEB-17

5. The transaction appears in the Transactions Available for Reconciliation Report based on the amount.


The issue has the following business impact:
Due to this issue, users cannot reconcile the transactions

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