EGL: Ledger Activity Report (GLS7002) and Closing Trial Balance (GLS1003) Appear To Use The Like Instead Of Equal To Operand

(Doc ID 2146439.1)

Last updated on OCTOBER 26, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


The Ledger Activity Report (GLS7002) and Closing Trial Balance (GLS1003) seem to be using 'Like' instead of an 'Equal to' operand. For example, If there are more than one Business Units that start with CTR (e.g CTR, CTRA, CTRB, CTRC) and this report produces activity for all these Business Units, which is not expected.
The issue can be reproduced with the following steps:

1. Make sure to have some Ledger activity for couple of Business units that start with a common alphabets.(e.g. SRA & SRAB)
1. Run ledger Activity report by navigating to General Ledger -> General Reports -> Ledger Activity and choose SRA as the business unit
2. Review generated report and note that it lists both the SRA and SRAB business unit. 


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