Enhancement Request to Make Query Manager Dynamically Change the Expression to Match the Language the User Is Logged In
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.
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.
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