SQL View PERSONAL_DT_FST Returns the Same Value for NAME and NAME_DISPLAY Fields. (Doc ID 1410163.1)

Last updated on OCTOBER 09, 2015

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


PERSONAL_DT_FST view returns the same result for NAME and NAME_DISPLAY Fields.
The result of those fields is always NAME_DISPLAY.

EXPECTED BEHAVIOR
-----------------------
The PERSONAL_DT_FST SQL view, should return different results for NAME and NAME_DISPLAY fields.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to the Application Designer
2. Open the Record PERSONAL_DT_FST
3. Review the SQL View.
4. Open the SQL definition NAME_SBR_SQL
5. The SQL uses twice the NAME_DISPLAY field

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