For Advising Notes Within Self Service, Effective Date Logic Missing On 'Created By' Field

(Doc ID 2017078.1)

Last updated on NOVEMBER 01, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.


Name display is not correct, because it is not pulling the max effective dated row.

Effected dated logic is not used within record SAA_NAME_OPRID and within Page SAA_SS_ADVNOTE_SUM, as seen below:

The issue can be reproduced at will with the following steps:
1. Review of code within DEMO.  You can review the SQL view code from within App Designer.  (SAA_NAME_OPRID)

2. Navigate to Self service where the name display is incorrect for "Created By' field within grid control.  (within Page SAA_SS_ADVNOTE_SUM)

The issue has the following business impact:
Due to this issue, users cannot see the current name within the grid control.


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