My Oracle Support Banner

20D: Error searching in Manage Journals (Doc ID 2731250.1)

Last updated on NOVEMBER 25, 2020

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.10.0 version, Create and Manage Journals

Executing Saved Searches with criteria such as Status equals Unposted within Manage journals sometimes produces one of the following errors:
Attempt to set a parameter name that does not occur in the SQL: BatchStatus
Attempt to set a parameter name that does not occur in the SQL: PostedBatchStatus

STEPS
-------------
The issue can be reproduced at will with the following steps:
1. Navigate to Journals --> Manage Journals
2. Execute Saved Search which contains Status as a filter criteria

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.