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 AUGUST 09, 2017

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.
See replication for details :  

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