Enhancement Request to Make Query Manager Dynamically Change the Expression to Match the Language the User Is Logged In (Doc ID 1998183.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
PeopleSoft Enterprise SCM Order Management - Version 8 SP1 and later
PeopleSoft Enterprise SCM Inventory - Version 8 SP1 and later
PeopleSoft Enterprise SCM Manufacturing - Version 8.4 and later
Information in this document applies to any platform.

Symptoms

When using Query Manager when logged in using a language which is not the base language and querying a text field (NAME1 for example) from a table (PS_CUSTOMER for example) which has a language related table associated (PS_CUSTOMER_LANG), the system is modifying the SELECT part of the SQL to display the value of NAME1 from the language related table.

However, the criteria part of the SQL is not updated and continues to run against the PS_CUSTOMER base table.

This can lead to incorrect query results in some situations as in the following example:

PS_CUSTOMER.NAME1 = Advanced Consulting
PS_CUSTOMER_LANG.NAME1 = Advanced Consulting FR

Using Query Manager when logged in using a language which is not the base language:
SELECT NAME1 FROM PS_CUSTOMER WHERE NAME1 LIKE 'Advanced Consulting%'  displays this result: Advanced Consulting FR
SELECT NAME1 FROM PS_CUSTOMER WHERE NAME1 LIKE 'Advanced Consulting F%' does not return any row

This Enhancement Request is to make Query Manager dynamically change the Expression to match the language the user is logged in.

Changes

 

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