AR Transactions Summary Form: Cannot Query Transactions By Legal Entity using % (Doc ID 1597167.1)

Last updated on FEBRUARY 15, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transactions Related

ACTUAL BEHAVIOR
---------------
In the AR Transaction Summary Workbench it is not possible to query by legal entity using %.

Example:
Query with Exact LE Name : Vision Operations

This returns the data

Does not work if user tries to query using:
Vi% Operations

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Transactions > Transactions
Create three (3) transaction, for example whose transaction number and Legal Entity as follows:
  13009 - Vision Operations
  10020 - Vision Corporation
  13424 - Vision Operations

Navigation:  Transactions > Summary
Query giving below information
  Date = 15-OCT-2013
  Legal entity Name - Vision Operations

It displays 2 transaction

Navigation:  Transactions > Summary
Query giving below information
  Date = 15-OCT-2013
  Legal entity Name - Visio%perations

Does not return any rows

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