Ledger Inquiry Shows Same Journal Lines For All Accounts When Search Is Done Using Wildcard (%) In Account Parameter Field

(Doc ID 2134044.1)

Last updated on NOVEMBER 25, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 Image 10, Journal / Ledger Inquiry

Journal / Ledger Inquiry does not return same results when Account is left blank and when wildcard is used in Account field

Expecting same number of journals to be returned in both cases

The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > General Ledger > Review Financial Information > Ledger
2. Enter BU, Ledger, Fiscal Year and Period
3. Enter Search criteria leaving all ChartFields blank
- Result two journal lines each returned, from two journals, for accounts 100000 and 100001

Note: There are two separate journal entries containing both accounts 100000 and 100001 posted to the ledger that match above criteria

4. Re-enter same search criteria but enter '10%' in Account field
- Result 4 journal lines each returned, from both journals, for same accounts 100000 and 100001
- Total amount remains the same



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