DAILY JOURNALS ERRORS: NO TRANSACTIONS EXIST THAT MATCH THE CRITERIA ENTERED (Doc ID 2021180.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version 11.5.10.2 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Acct'ing-Jounals,Accrual,Reval

Navigate to  > Other Deal Items
Company: ABC
Deal Date: 05-MAR-2015
Transfer Date: 05-MAR-2015

There are three transactions
Execute the concurrent program ‘Program - Accounting Streamline Processing’ with the following parameters:
Company:ABC
Batch end Date: 28-MAY-2015
Start Process From: Revaluations
End Process After: Daily Journals - Transfer to GL

Revaluation Processing
============================================
Captured revaluation rates for batch 11011.
Generated revaluation details for batch 11011.
Authorized revaluation details for batch 11011.
New batch 11011 was created.

Accrual Processing
============================================
Generated accrual details for batch 11011.
Authorized accrual details for batch 11011.

Journal Generation Processing
============================================
Start journal generation for company ABC for the following range of batch ID: 11011 - 11011.
Start journal generation for batch ID 11011.
End journal generation for batch ID 11011.
End journal generation for company ABC for the following range of batch ID: 11011 - 11011.
Generated journal details for batch 11011.


Journal Transfer Processing
============================================
Start journal transfer process for company ABC.
Start journal transfer process for company ABC and batch ID 11011.
End journal transfer process for company ABC and batch ID 11011.
End journal transfer process for company ABC.
Transferred journal details for batch 11011.

+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Now Navigate to Accounting > Daily Journals

Click on Transfer Journals
Query up Company: ABC
Batch ID: 11011

We get the Error: ‘No transactions exist that match the criteria entered.’

Attached as xtr_accounting.docx
 

ERROR
-----------------------
Errors: No transactions exist that match the criteria entered.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run accounting

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete accounting

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