My Oracle Support Banner

EGL9.2: Ledger Inquiry Criteria Using Wildcard (i.e.%) in the Chartfield filter Value, When Drilled Down to Specific Account, Returns Values That Include Accounts Other Than Specified. (Doc ID 2284523.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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

Symptoms

Issue:

When running the Ledger Inquiry using a percent (%) in the Chartfield filter value, the returned results when drilled to a specific account include accounts other than the specified account.


Steps to replicate:

1. Navigate to General Ledger > Review Financial Information > Ledger
   In Ledger Inquiry, populate Chartfield Criteria with (example):
         Account '682%'
         Department '14000'
2. Click Search.
3. Select an Account value to view the activity.

The Activity screen shows journals with lines not using the selected Account chartfield value.

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
References


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